Cách tao database Oracle bằng dòng lệnh

Nếu không có công cụ dbca bạn có thể tạo database bằng dòng lệnh như sau
CREATE DATABASE ORCL
   USER SYS IDENTIFIED BY sys_password
   USER SYSTEM IDENTIFIED BY system_password
   LOGFILE GROUP 1 ('/u1/ORCL/redo01.log') SIZE 100M,
           GROUP 2 ('/u1/ORCL/redo02.log') SIZE 100M,
           GROUP 3 ('/u1/ORCL/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET UTF8
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u1/ORCL/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/u1/ORCL/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/u1/ORCL/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u1/ORCL/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/u1/ORCL/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
@/oracle/app/product/10.2.0/rdbms/admin/catalog.sql
@/oracle/app/product/10.2.0/rdbms/admin/catproc.sql
run trong system
@/oracle/app/product/10.2.0/sqlplus/admin/pupbld.sql
 
SQL>@?/rdbms/admin/utltkprf.sql
SQL>@?/rdbms/admin/utlxplan.sql
SQL>@?/rdbms/admin/utlpwdmg.sql
SQL>@?/rdbms/admin/utlbstat.sql
SQL>@?/rdbms/admin/utlestat.sql
SQL>@?/rdbms/admin/owminst.plb
SQL>@?/javavm/install/initjvm.sql
SQL>@?/xdk/admin/initxml.sql
SQL>@?/rdbms/admin/utldtree.sql
SQL>@?/rdbms/admin/catblock.sql
SQL>@?/rdbms/admin/caths.sql
SQL>@?/xdk/admin/xmlja.sql
SQL>@?/rdbms/admin/catjava.sql
SQL>@?/rdbms/admin/catexf.sql
@$ORACLE_HOME/rdbms/admin/catexf.sql
@G:\app\fiscal.dba\product\11.2.0\dbhome_1\RDBMS\ADMIN\exfeapvs.plb 
Web hosting by Somee.com