createdb.sql脚本

oracle9i创库脚本

CREATE DATABASE rmanLOGFILE
GROUP 1 ('/data/rman/log01_01.log') SIZE 50M,
GROUP 2 ('/data/rman/log02_01.log') SIZE 50M,
GROUP 3 ('/data/rman/log03_01.log') SIZE 50M,
GROUP 4 ('/data/rman/log04_01.log') SIZE 50M,
GROUP 5 ('/data/rman/log05_01.log') SIZE 50M
DATAFILE '/data/rman/system01.dbf' SIZE 300M AUTOEXTEND ON NEXT 10M MAXSIZE 32767M
extent management localDEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/data/rman/temp01.dbf' SIZE 1000M
AUTOEXTEND ON NEXT 10M MAXSIZE 32767M
UNDO TABLESPACE UNDOTBS1 datafile '/data/rman/undotbs01.dbf' SIZE 2000M AUTOEXTEND ON NEXT 10M
MAXSIZE 32767M
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16;

oracle10g创库脚本

CREATE DATABASE itownetLOGFILE
GROUP 1 ('/data_disk/itownet/log01_01.log') SIZE 50M,
GROUP 2 ('/data_disk/itownet/log02_01.log') SIZE 50M,
GROUP 3 ('/data_disk/itownet/log03_01.log') SIZE 50M
DATAFILE '/data_disk/itownet/system01.dbf' SIZE 300M REUSE
AUTOEXTEND ON NEXT 10M MAXSIZE 32767M
sysaux datafile '/data_disk/itownet/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 32767M
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/data_disk/itownet/temp01.dbf' SIZE 1000M
AUTOEXTEND ON NEXT 10M MAXSIZE 32767M
UNDO TABLESPACE UNDOTBS1 datafile '/data_disk/itownet/undotbs01.dbf' SIZE 2000M AUTOEXTEND ON NEXT 10M MAXSIZE 32767M
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16;