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;










