一个手工建库脚本

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;

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

转载于:http://blog.itpub.net/10972173/viewspace-366131/