sql*plus创建数据库
create database "MYDB"
-- user SYS identified by change_on_install
-- user SYSTEM identified by manager
logfile
group 1 ( '/test/redolog/redo01a.redo','/test/redolog/reduo01b.redo','/test/redo01c.redo') size 50M blocksize 512,
group 2 ( '/test/redolog/redo02a.redo','/test/redolog/reduo02b.redo','/test/redo02c.redo') size 50M blocksize 512,
group 3 ( '/test/redolog/redo03a.redo','/test/redolog/reduo03b.redo','/test/redo03c.redo') size 50M blocksize 512,
-- MAXLOGFILES 5
-- MAXLOGMEMBERS 10
-- maxloghistory 100
-- maxdatafiles 100
-- character set UTF-8
-- national character set ZHS16GBK
extent management local
datafile '/test/oradata/MYDB/system01.dbf' size 625M reuse
SYSAUX datafile '/test/oradata/MYDB/sysaux01.dbf' size 625M reuse
default tablespace users
datafile '/test/oradata/MYDB/user01.dbf' size 100M reuse
default temporary tablespace temp
tempfile '/test/oradata/MYDB/temp01.dbf' size 50M reuse
undo tablespace undo
datafile '/test/oradata/MYDB/undo01.dbf' size 50M reuse
tablespace test
datafile '/test/oradata/MYDB/test.dbf' size 20M resue autoextend on
set time_zone='+8:00'
---------
-- character set UTF-8 注释掉
是因为:
ORA-02236: invalid file name 数据库软件是 11.2.0版本
弱弱问一下 上面有哪些语法错误?
------解决方案--------------------是不是表空间名不要加单引号?
------解决方案--------------------
SQL code
group 3 ( '/test/redolog/redo03a.redo','/test/redolog/reduo03b.redo','/test/redo03c.redo') size 50M blocksize 512,