CREATE DATABASE book
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'D:\oracle\product\10.2.0\oradata\book\SYSTEM01.DBF' SIZE 250M REUSE
SYSAUX DATAFILE 'D:\oracle\product\10.2.0\oradata\book\sysaux01.dbf' SIZE 120M REUSE
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'F:\oracle\product\10.2.0\oradata\book\temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE "BOOKBS1" DATAFILE 'D:\oracle\product\10.2.0\oradata\book\bookbs01.dbf' SIZE
200M REUSE
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0\oradata\book\redo01.log') SIZE 10240K,
GROUP 2 ('D:\oracle\product\10.2.0\oradata\book\redo02.log') SIZE 10240K,
GROUP 3 ('D:\oracle\product\10.2.0\oradata\book\redo03.log') SIZE 10240K;
在命令行执行时报错，请高手指点
SQL> start D:\book.sql
CREATE DATABASE book
*
第 1 行出现错误:
ORA-01501: CREATE DATABASE ??
ORA-00200: ????????
ORA-00202: ????: ''D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOOK\CONTROL01.CTL''
ORA-27038: ?????????
OSD-04010: ?????? <create> ????, ??????????????
------解决方法--------------------------------------------------------
我收藏的一份建库脚本，供参考
http://blog.csdn.net/ppp_10001/archive/2009/10/17/4687899.aspx
------解决方法--------------------------------------------------------
下面的控制文件已存在:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\BOOK\CONTROL01.CTL'
建议你把已有的数据库删除后再创建,或改变一个路径.
