首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

是因为:ORA-02236: invalid file name

2012-02-04 
sql*plus创建数据库create database MYDB--user SYSidentifiedbychange_on_install--user SYSTEMidentif

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, 

热点排行