CREATE DATABASE test
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 200
MAXLOGMEMBERS 5
MAXDATAFILES 500
DATAFILE '/oracle/oradata/test/system01.dbf' SIZE 250M
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oracle/oradata/test/temp01.dbf' SIZE 20M
UNDO TABLESPACE "UNDOTBS"
DATAFILE '/oracle/oradata/test/undotbs01.dbf' SIZE 20M
CHARACTER SET zhs16gbk
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oracle/oradata/test/redo01.log') SIZE 10M,
GROUP 2 ('/oracle/oradata/test/redo02.log') SIZE 10M,
GROUP 3 ('/oracle/oradata/test/redo03.log') SIZE 10M;
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 200
MAXLOGMEMBERS 5
MAXDATAFILES 500
DATAFILE '/oracle/oradata/test/system01.dbf' SIZE 250M
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oracle/oradata/test/temp01.dbf' SIZE 20M
UNDO TABLESPACE "UNDOTBS"
DATAFILE '/oracle/oradata/test/undotbs01.dbf' SIZE 20M
CHARACTER SET zhs16gbk
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oracle/oradata/test/redo01.log') SIZE 10M,
GROUP 2 ('/oracle/oradata/test/redo02.log') SIZE 10M,
GROUP 3 ('/oracle/oradata/test/redo03.log') SIZE 10M;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10972173/viewspace-366131/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
