spool dbcreate.log;
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
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
阅读(318) | 评论(0) | 转发(0) |