ITPub博客

首页 > 数据库 > Oracle > Sql Statement for create a new 10g database

Sql Statement for create a new 10g database

原创 Oracle 作者:linnong 时间:2010-10-27 11:52:56 0 删除 编辑

​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;

[@more@]

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

请登录后发表评论 登录
全部评论
  • 博文量
    6
  • 访问量
    3239