准备手工建立一个数据库,名字mynewdb
实例已可以启动
连接实例后,启动到nomount模式,
输入一下sql语句后,报错。
sql>create database mynewdb
maxinstances 1
maxloghistory 1
maxlogfiles 5
maxlogmembers 5
maxdatafiles 100
datafile 'd:\oracle\oradata\mynewdb\system.dbf' size 50m
undo tablespace undotbs datafile
'd:\oracle\oradata\mynewdb\undotbs.dbf' size 20m
autoextend on next 5120k maxsize unlimited
default temporary tablespace tempts
character set us7ascii
national character set al16utf16
logfile group 1 ('d:\oracle\oradata\mynewdb\redo01.log') size 10m,
group 2 ('d:\oracle\oradata\mynewdb\redo02.log') size 10m,
group 3 ('d:\oracle\oradata\mynewdb\redo03.log') size 10m;
运行后报错,请高手们看看,这个语句有没有错误
实例已可以启动
连接实例后,启动到nomount模式,
输入一下sql语句后,报错。
sql>create database mynewdb
maxinstances 1
maxloghistory 1
maxlogfiles 5
maxlogmembers 5
maxdatafiles 100
datafile 'd:\oracle\oradata\mynewdb\system.dbf' size 50m
undo tablespace undotbs datafile
'd:\oracle\oradata\mynewdb\undotbs.dbf' size 20m
autoextend on next 5120k maxsize unlimited
default temporary tablespace tempts
character set us7ascii
national character set al16utf16
logfile group 1 ('d:\oracle\oradata\mynewdb\redo01.log') size 10m,
group 2 ('d:\oracle\oradata\mynewdb\redo02.log') size 10m,
group 3 ('d:\oracle\oradata\mynewdb\redo03.log') size 10m;
运行后报错,请高手们看看,这个语句有没有错误
手动建太麻烦,还容易出错。不适合初学者。