oracle将数据生成sql语句,通过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的朋友，手动建库可以考虑这种方式哟