프로그래밍/DataBase

DataBase 생성 수동

jonelove71 2009. 6. 26. 09:02
1. export ORACLE_SID= ORA92
2. sqlplus '/ as sysdba'
sql> startup nomount
3. Create Database <- 첨부화일 cdb.sql
4. User Tablespace 생성
5. sql>@$ORACLE_HOME/rdbms/admin/catalog.sql
   sql>@$ORACLE_HOME/rdbms/admin/catproc.sql
6. $sqlplus system/mamager
  sql>@$ORACLE_HOME/sqlplus/admin/pupbld.sql
7. shutdown
8. $sqlplus '/ as sysdba'