oracle create command

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


posted on 2012-04-12 21:26  c3tc3tc3t  阅读(178)  评论(0)    收藏  举报