2009. 7. 24. 15:32

오라클 DB생성과 DB유져생성

[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