Parrot & SQL
오라클 DB생성과 DB유져생성
bestakas
2009. 7. 24. 15:32
[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