环境:winxp
版本
racle 10g
我打算手工建立一DB
初始化参数建立好之后,,将其转到nomount 状态,,,然后执行如下sql脚本(自己编写的)
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
CREATE DATABASE MATRIX3
DATAFILE
'E:\ORACLE_DB_MATRIX3\SYSTEM01.DBF'SIZE 440M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
'E:\ORACLE_DB_MATRIX3\UNDOTBS01.DBF' SIZE 5M AUTOEXTEND ON NEXT 1280KMAXSIZE UNLIMITED LOGGONG EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
'E:\ORACLE_DB_MATRIX3\SYSAUX01.DBF'SIZE 250M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED LOGGONG EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
'E:\ORACLE_DB_MATRIX3\USERS01.DBF' SIZE 25MAUTOEXTEND ON NEXT 5120KMAXSIZE UNLIMITED
'E:\ORACLE_DB_MATRIX3\TEMP.DBF'SIZE 20MAUTOEXTENT ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'E:\ORACLE_DB_MATRIX3\TEMP.DBF' ,
UNDO
TABLESPACE UNDOTBS1 DATAFILE 'E:\ORACLE_DB_MATRIX3\UNDOTBS01.DBF' ,
SYSTEM
TABLESPACE SYSTEM DATAFILE 'E:\ORACLE_DB_MATRIX3\SYSTEM01.DBF',
SYSAUX
TABLESPACE SYSAUX DATAFILE 'E:\ORACLE_DB_MATRIX3\SYSAUX01.DBF' ,
USERS
TABLESPACE USERSDTAFILE'E:\ORACLE_DB_MATRIX3\USERS01.DBF'
LOGFILE
GROUP 1 ('E:\ORACLE_DB_MATRIX3\REDO01.LOG')SIZE 10M,
GROUP 2 ('E:\ORACLE_DB_MATRIX3\REDO02.LOG')SIZE 10M,
GROUP 3 ('E:\ORACLE_DB_MATRIX3\REDO03.LOG')SIZE 10M
CHARACTER SET ZHS16GBK;
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
执行之后出现了很多错误,,,是语法问题,,,大家帮忙改正一下,,,多谢了
|