以下是创建数据库的代码:
spool alter01.log;
create database test
user sys IDENTIFIED BY oracle
user system identified by oracle
logfile group 1 ('/u01/oracle/oracle/oradata/bbk/redo01.log') size 100M,
group 2 ('/u01/oracle/oracle/oradata/bbk/redo02.log') size 100M,
group 3 ('/u01/oracle/oracle/oradata/bbk/redo03.log') size 100M
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 100
character set UTF8
national character set AL16UTF16
extent management local
datafile '/u01/oracle/oracle/oradata/bbk//system01.dbf' size 325M reuse
sysaux datafile '/u01/oracle/oracle/oradata/bbk/sysaux01.dbf' size 325M reuse
default tabalespace users
datafile '/u01/oracle/oracle/oradata/bbk/users01.dbf' size 500M reuse autoextend on maxsize unlimited
default temporary tablespace temptsl
tempfile 'u01/oracle/oracle/oradata/bbk/temp01.dbf'size 20M reuse
undo tabalespace undotbs01
datafile '/u01/oracle/oracle/oradata/bbk/undotbs01.dbf' size 200M reuse autotxtend on maxsize unlimited;
spool off;
spool alter01.log;
create database test
user sys IDENTIFIED BY oracle
user system identified by oracle
logfile group 1 ('/u01/oracle/oracle/oradata/bbk/redo01.log') size 100M,
group 2 ('/u01/oracle/oracle/oradata/bbk/redo02.log') size 100M,
group 3 ('/u01/oracle/oracle/oradata/bbk/redo03.log') size 100M
maxlogfiles 5
maxlogmembers 5
maxloghistory 1
maxdatafiles 100
character set UTF8
national character set AL16UTF16
extent management local
datafile '/u01/oracle/oracle/oradata/bbk//system01.dbf' size 325M reuse
sysaux datafile '/u01/oracle/oracle/oradata/bbk/sysaux01.dbf' size 325M reuse
default tabalespace users
datafile '/u01/oracle/oracle/oradata/bbk/users01.dbf' size 500M reuse autoextend on maxsize unlimited
default temporary tablespace temptsl
tempfile 'u01/oracle/oracle/oradata/bbk/temp01.dbf'size 20M reuse
undo tabalespace undotbs01
datafile '/u01/oracle/oracle/oradata/bbk/undotbs01.dbf' size 200M reuse autotxtend on maxsize unlimited;
spool off;
Process ID: 4316
Session ID: 170 Serial number: 3
这是报错信息!
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 10
ORA-00604: error occurred at recursive SQL level 1
ORA-01119: error in creating database file 'u01/oracle/oradata/test/temp01.dbf'
ORA-27040: file create error, unable to create file
以上是错误信息