手工建库脚本

CREATE DATABASE test
MAXINSTANCES 8
MAXLOGHISTORY 256
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 200
LOGFILE
    GROUP 1 ('/u01/app/oracle/oradata/test/redo01.dbf') size 50m,
    GROUP 2 ('/u01/app/oracle/oradata/test/redo02.dbf') size 50m,
    GROUP 3 ('/u01/app/oracle/oradata/test/redo03.dbf') size 50m
DATAFILE '/u01/app/oracle/oradata/test/system01.dbf' size 600m extent management local
SYSAUX DATAFILE '/u01/app/oracle/oradata/test/sysaux01.dbf' size 500m
UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/test/undo01.dbf' size 100m
SMALLFILE DEFAULT TABLESPACE USERS DATAFILE '/u01/app/oracle/oradata/test/users01.dbf' size 100m
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/oradata/test/temp01.dbf' size 100m
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
USER SYS IDENTIFIED BY ORACLE11GDB
USER SYSTEM IDENTIFIED BY ORACLE11GDB
;

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

转载于:http://blog.itpub.net/21175589/viewspace-755365/