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版本
  弱弱问一下 上面有哪些语法错误？

每个datafile之间应该有逗号吧。
我的控制文件重建语句：
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG
  MAXLOGFILES 16
  MAXLOGMEMBERS 3
  MAXDATAFILES 100
  MAXINSTANCES 8
  MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\REDO01.LOG' SIZE 50M BLOCKSIZE 512,
  GROUP 2 'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\REDO02.LOG' SIZE 50M BLOCKSIZE 512,
  GROUP 3 'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\REDO03.LOG' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE

DATAFILE
  'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\SYSTEM01.DBF',
  'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\SYSAUX01.DBF',
  'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\UNDOTBS01.DBF',
  'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\USERS01.DBF',
  'E:\ORACLE\APP\HUANGDH\ORADATA\ORCL\EXAMPLE01.DBF'
CHARACTER SET AL32UTF8
;

你建库 应该跟这个格式也差不多。。