创建数据命令:
create database moracle
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/moracle/oradata/moracle/system.dbf' size 50M
UNDO TABLESPACE undotbs DATAFILE '/moracle/oradata/moracle/undotbs.dbf' SIZE 50M
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/moracle/oradata/moracle/redo01.log') SIZE 100M,
GROUP 2 ('/moracle/oradata/moracle/redo02.log') SIZE 100M,
GROUP 3 ('/moracle/oradata/moracle/redo03.log') SIZE 100M;
脚本最后一个“;”造成ORA-00911: invalid character,在命令行输入上述命令时,先换行,再输入;结束脚本。