通过dbca工具生成创建数据库的sql语句

1. 进入相关目录

   cd /u01/app/oracle/product/11.2.0.4/db_1/assistants/dbca/templates
  
2. 通过dbca生成相关脚本

   dbca -silent -generateScripts -customCreate -templateName New_Database.dbt -gdbName ora1124
  
3. 查看相关脚本

   cd $ORACLE_BASE/admin/ora1124/scripts/
  
   cat CreateDB.sql
   SET VERIFY OFF
   connect "SYS"/"&&sysPassword" as SYSDBA
   set echo on
   spool /u01/app/oracle/admin/ora1124/scripts/CreateDB.log append
   startup nomount pfile="/u01/app/oracle/admin/ora1124/scripts/init.ora";
   CREATE DATABASE "ora1124"
   MAXINSTANCES 8
   MAXLOGHISTORY 1
   MAXLOGFILES 16
   MAXLOGMEMBERS 3
   MAXDATAFILES 100
   DATAFILE '/u01/app/oracle/oradata/ora1124/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/app/oracle/oradata/ora1124/sysaux01.dbf' SIZE 600M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
   SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/ora1124/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
   SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/oradata/ora1124/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
   CHARACTER SET WE8MSWIN1252
   NATIONAL CHARACTER SET AL16UTF16
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/ora1124/redo01.log') SIZE 51200K,
   GROUP 2 ('/u01/app/oracle/oradata/ora1124/redo02.log') SIZE 51200K,
   GROUP 3 ('/u01/app/oracle/oradata/ora1124/redo03.log') SIZE 51200K
   USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
   spool off
  
顺便说一句，考OCM的朋友，手动建库可以考虑这种方式哟

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29843794/viewspace-1292834/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29843794/viewspace-1292834/