2009. 7. 24. 15:32
오라클 DB생성과 DB유져생성
2009. 7. 24. 15:32 in Parrot & SQL
[oracle@AkasLinux emd]$ sqlplus SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 23 15:20:00 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Enter user-name: system Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> create tablespace oracle_bas datafile '/home/oracle/oracle11/oradata/orcl/bas.dbf' size 10M; Tablespace created. SQL> create user bestakas identified by password default tablespace oracle_bas; User created. SQL> grant connect, resource to bestakas; Grant succeeded. SQL> connect bestakas/password Connected. SQL> |
Let's Go Oracle
'Parrot & SQL' 카테고리의 다른 글
Oracle Commit와 Rollback,Transaction(커밋,롤백,트랜잭션)의 개념. (0) | 2009.07.29 |
---|---|
오라클 테이블 작성. (0) | 2009.07.24 |
오라클 vi를 이용해 SQL문 작성시.. (0) | 2009.07.24 |
오라클 계정으로 오라클 가동.. (0) | 2009.07.24 |
오라클 system, sys 비밀번호 재설정 (0) | 2009.07.24 |