CEATE DATABASE dbtest
USER SYS IDENTIFILED '111'
USER SYSTEM IDENTIFILED BY '000'
CONTROFILE REUSE
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0\oradata\dbtest01.log') SIZE 10M
GROUP 2 ('D:\oracle\product\10.2.0\oradata\dbtest02.log') SIZE 10M
MAXLOGFILES 10
MAXLOGMEMBERS 10
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
DATAFILE 'D:\oracle\product\10.2.0\oradata\sys01.dbf' SIZE 100M REUSE
EXTENT MANAGEMENT LOCAL
DEFUALT TABLESPACE tbs_1
DEFAULT TEMPOPRARY TABLESPACE temptel
TEMPFILE 'D:\oracle\product\10.2.0\oradata\dbtest01.dbf' SIZE 10M REUSE;
用上面的语句创建数据库时,老提示“ORA-00900: 无效 SQL 语句”,是何原因啊???
USER SYS IDENTIFILED '111'
USER SYSTEM IDENTIFILED BY '000'
CONTROFILE REUSE
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0\oradata\dbtest01.log') SIZE 10M
GROUP 2 ('D:\oracle\product\10.2.0\oradata\dbtest02.log') SIZE 10M
MAXLOGFILES 10
MAXLOGMEMBERS 10
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
DATAFILE 'D:\oracle\product\10.2.0\oradata\sys01.dbf' SIZE 100M REUSE
EXTENT MANAGEMENT LOCAL
DEFUALT TABLESPACE tbs_1
DEFAULT TEMPOPRARY TABLESPACE temptel
TEMPFILE 'D:\oracle\product\10.2.0\oradata\dbtest01.dbf' SIZE 10M REUSE;
用上面的语句创建数据库时,老提示“ORA-00900: 无效 SQL 语句”,是何原因啊???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货