문서의 이전 판입니다!
$ export ORACLE_SID=orcl $ echo $ORACLE_SID $ sqlplus / as sysdba SQL> select instance_name from v$instance;
$ sqlplus sys/oracle@rcat as sysdba SQL> select instance_name from v$instance;
create tablespace rcat_ts datafile '/u01/app/oracle/oradata/rcat/rcat01.dbf' size 30m;
$ cat ts.sql create tablespace rcat_ts datafile '/u01/app/oracle/oradata/rcat/rcat01.dbf' size 30m;
$ sqlplus sys/oracle@rcat as sysdba @ts.sql
<code>
$ sqlplus sys/oracle@rcat as sysdba
SQL> @ts.sql
</code>
===== USER 생성 =====
- vi user.sql <code>
create user rcatowner identified by oracle
temporary tablespace temp
default tablespace rcat_ts
quota unlimited on rcat_ts;
grant recovery_catalog_owner to rcatowner;
</code>
- sqlplus 로 바로 실행한다. <code>
$ sqlplus sys/oracle@rcat as sysdba @user.sql
</code>
<code>
$ sqlplus sys/oracle@rcat as sysdba
SQL> @user.sql
</code>