CREATE DATABASE gaoyu
LOGFILE
GROUP 1 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo01.log') SIZE 100m,
GROUP 2 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo02.log') SIZE 100m,
GROUP 3 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo03.log') SIZE 100m
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
sysaux datafile 'E:\oracle\product\10.1.0\oradata\gaoyu\sysaux01.dbf' size 120M reuse autoextend on next 10240K maxsize unlimited
UNDO TABLESPACE undotbs DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\undotbs01.dbf' SIZE 500M;
default temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' size 20M reuse autoextend on next 640Kmaxsize unlimited 错误如下:
oracle instance terminate .Disconnection forced
并且我发现:sysaux datafile 'E:\oracle\product\10.1.0\oradata\gaoyu\sysaux01.dbf' size 120M reuse autoextend on next
和default temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' size 20M reuse autoextend on next 640Kmaxsize unlimited
对应的文件均没有生成。始终是这两条语句导致我错误,
请教高手!!!!
LOGFILE
GROUP 1 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo01.log') SIZE 100m,
GROUP 2 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo02.log') SIZE 100m,
GROUP 3 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo03.log') SIZE 100m
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
sysaux datafile 'E:\oracle\product\10.1.0\oradata\gaoyu\sysaux01.dbf' size 120M reuse autoextend on next 10240K maxsize unlimited
UNDO TABLESPACE undotbs DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\undotbs01.dbf' SIZE 500M;
default temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' size 20M reuse autoextend on next 640Kmaxsize unlimited 错误如下:
oracle instance terminate .Disconnection forced
并且我发现:sysaux datafile 'E:\oracle\product\10.1.0\oradata\gaoyu\sysaux01.dbf' size 120M reuse autoextend on next
和default temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' size 20M reuse autoextend on next 640Kmaxsize unlimited
对应的文件均没有生成。始终是这两条语句导致我错误,
请教高手!!!!
楼主在什么状态下执行这些命令的?mount 还是nomout, 把你的操作过程也说明下啊. Windows Oracle 10G手工创建数据库
http://blog.csdn.net/tianlesoftware/archive/2009/10/17/4680230.aspx
里面的“640Kmaxsize”连着了,改成640K maxsize
default temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' size 20M reuse autoextend on next 640Kmaxsize unlimited 中间怎么就使用分号了呢?这个肯定不正确的啊
oracle instance terminate .Disconnection forced
CREATE DATABASE gaoyu
LOGFILE
GROUP 1 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo01.log') SIZE 100m,
GROUP 2 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo02.log') SIZE 100m,
GROUP 3 ('E:\oracle\product\10.1.0\oradata\gaoyu\redo03.log') SIZE 100m
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8
DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\system01.dbf' SIZE 1000M EXTENT MANAGEMENT LOCAL
sysaux datafile 'E:\oracle\product\10.1.0\oradata\gaoyu\sysaux01.dbf' size 120M
UNDO TABLESPACE undotbs DATAFILE 'E:\oracle\product\10.1.0\oradata\gaoyu\undotbs01.dbf' SIZE 500M
default temporary tablespace temp tempfile 'E:\oracle\product\10.1.0\oradata\gaoyu\temp01.dbf' size 500M