- 论坛徽章:
- 0
|
oracle8.1.7 for solaris x86 建库所遇到的问题
最简单的建库教本:
CREATE DATABASE CDJJ
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 9
MAXLOGMEMBERS 3
MAXDATAFILES 1000
DATAFILE '/oracle/app/oracle/oradata/CDJJ/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oracle/app/oracle/oradata/CDJJ/temp01.dbf' SIZE 40M REUSE AUTOEXTEND OFF
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oracle/app/oracle/oradata/CDJJ/undotbs01.dbf' SIZE 10240M REUSE AUTOEXTEND OFF
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oracle/app/oracle/oradata/CDJJ/redo01.log') SIZE 102400K,
GROUP 2 ('/oracle/app/oracle/oradata/CDJJ/redo02.log') SIZE 102400K,
GROUP 3 ('/oracle/app/oracle/oradata/CDJJ/redo03.log') SIZE 102400K;
@?/rdbms/admin/catalog
@?/rdbms/admin/catproc |
|