Sql Statement for create a new 10g database
时间:2010-10-27 来源:linnong
Create database ocm1
maxinstances 1
maxloghistory 1
maxlogfiles 36
maxlogmembers 2
maxdatafiles 256
datafile '/rdsk/oradata/ocm1/system01.dbf' size 512M reuse autoextend on next 10M max 2048M
default temporary tablespace temp tempfile '/rdsk/oradata/ocm1/temp01.dbf' size 2048m reuse autoextned off
extent management local
sysaux datafile '/rdsk/oradata/ocm1/sysaux01.dbf' size 512M autoextned on
undo tablespace undotbs1 datafile '/rdsk/oradata/ocm1/undotbs01.dbf' size 2048m reuse autoextend o extent management local
logfile
group 1 '/rdsk/oradata/ocm1/redo01.log' size 32M,
group 2 '/rdsk/oradata/ocm1/redo02.log' size 32M,
group 3 '/rdsk/oradata/ocm1/redo03.log' size 32M
character set zhs16gbk
national charaset set al16utf16;