oracle create command

最新推荐文章于 2021-04-15 17:15:09 发布

weixin_30510153

最新推荐文章于 2021-04-15 17:15:09 发布

阅读量117

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/or2-/archive/2012/04/12/2444744.html

版权

CREATE DATABASE "bbk"
        MAXDATAFILES 500
        MAXINSTANCES 8
        MAXLOGFILES 32
        CHARACTER SET "UTF8"
        NATIONAL CHARACTER SET AL16UTF16
        ARCHIVELOG
        DATAFILE
                '/u01/oradata/bbk/system01.dbf' size 300M
        EXTENT MANAGEMENT LOCAL
        DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/oradata/bbk/tempts01.dbf' SIZE 100M

　　　EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/oradata/bbk/sysaux.dbf'
        UNDO TABLESPACE "UNDOTBS1"
        DATAFILE '/u01/oradata/bbk/undotbs01.dbf' SIZE 200M
        LOGFILE
GROUP 1(
        '/u01/oradata/bbk/redo01a.rdo',
        '/u01/oradata/bbk/redo01b.rdo'
       ) SIZE 100M,
GROUP 2 (
        '/u01/oradata/bbk/redo02a.rdo',
        '/u01/oradata/bbk/redo02b.rdo'
        ) SIZE 100M,
GROUP 3(
        '/u01/oradata/bbk/redo03a.rdo',
        '/u01/oradata/bbk/redo03b.rdo'
      ) SIZE 100M
;

spool off