日期:2014-05-17  浏览次数:22970 次

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,