第一步:编写脚本
注意参数文件中的表空间参数要和本语句中的UNDOTBS1一致
CREATE DATABASE orcl
LOGFILE
GROUP 1 ('e:\oracle\oradata\orcl1\redo01.log') size 50m reuse,
GROUP 2 ('e:\oracle\oradata\orcl1\redo02.log') size 100m reuse,
GROUP 3 ('e:\oracle\oradata\orcl1\redo03.log') size 100m reuse
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET ZHS16GBK
DATAFILE 'e:\oracle\oradata\orcl1\system01.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'e:\oracle\oradata\orcl1\sysaux01.dbf' SIZE 100M
default tablespace users DATAFILE 'e:\oracle\oradata\orcl1\user01.dbf' SIZE 10M
UNDO TABLESPACE UNDOTBS1 DATAFILE 'e:\oracle\oradata\orcl1\undo.dbf' SIZE 100M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'e:\oracle\oradata\orcl1\temp.dbf' SIZE 100M
运行
@?\rdbms/admin/catalog.sql
@?\rdbms/admin/catproc.sql
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/133126/viewspace-756665/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/133126/viewspace-756665/