第一步：编写脚本

注意参数文件中的表空间参数要和本语句中的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