[code]SQL> @/oracle/createdb.script
CREATE DATABASE orasql
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 20
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Process ID: 3991
Session ID: 18 Serial number: 10
[/code]
查看'?/rdbms/admin/dtxnspc.bsq' near line 20 是指定默认表空间的,因为在之前已经指定过一次默认表空间,这里报错。
[oracle@localhost controlfile]$ vim /oracle/product/database/rdbms/admin/dtxnspc.bsq
16 REM
17 REM create the default permanent tablespace for the database
18 REM
19 "D_CRTDPTS"
20 /
在createdb.script中将DEFAULT TABLESPACE tbs_1 去掉
重新运行脚本
SQL> @/oracle/createdb.script
Database created.
CREATE DATABASE orasql
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 20
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Process ID: 3991
Session ID: 18 Serial number: 10
[/code]
查看'?/rdbms/admin/dtxnspc.bsq' near line 20 是指定默认表空间的,因为在之前已经指定过一次默认表空间,这里报错。
[oracle@localhost controlfile]$ vim /oracle/product/database/rdbms/admin/dtxnspc.bsq
16 REM
17 REM create the default permanent tablespace for the database
18 REM
19 "D_CRTDPTS"
20 /
在createdb.script中将DEFAULT TABLESPACE tbs_1 去掉
重新运行脚本
SQL> @/oracle/createdb.script
Database created.
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




