41 lines
1.1 KiB
SQL
41 lines
1.1 KiB
SQL
CREATE DATABASE "9207"
|
|
USER sys IDENTIFIED BY syspass
|
|
USER system IDENTIFIED BY syspass
|
|
--CONTROLFILE REUSE
|
|
MAXLOGFILES 50
|
|
MAXLOGMEMBERS 5
|
|
MAXLOGHISTORY 9999
|
|
MAXINSTANCES 1
|
|
MAXDATAFILES 100
|
|
NOARCHIVELOG
|
|
--FORCE LOGGING
|
|
CHARACTER SET WE8ISO8859P1
|
|
NATIONAL CHARACTER SET AL16UTF16
|
|
EXTENT MANAGEMENT LOCAL
|
|
LOGFILE
|
|
GROUP 1 '/opt/oracle/oradata/9207/redo01.log' SIZE 30M,
|
|
GROUP 2 '/opt/oracle/oradata/9207/redo02.log' SIZE 30M,
|
|
GROUP 3 '/opt/oracle/oradata/9207/redo03.log' SIZE 30M,
|
|
GROUP 4 '/opt/oracle/oradata/9207/redo04.log' SIZE 30M,
|
|
GROUP 5 '/opt/oracle/oradata/9207/redo05.log' SIZE 30M
|
|
DATAFILE
|
|
'/opt/oracle/oradata/9207/system01.dbf' SIZE 50M AUTOEXTEND ON NEXT 50m MAXSIZE 4001M
|
|
UNDO TABLESPACE UNDOTBS
|
|
datafile '/opt/oracle/oradata/9207/undo_tbs01.dbf' SIZE 10m AUTOEXTEND ON NEXT 50m MAXSIZE 4001M
|
|
DEFAULT TEMPORARY TABLESPACE temp
|
|
TEMPFILE '/opt/oracle/oradata/9207/temp01.dbf' SIZE 50M AUTOEXTEND ON NEXT 50m MAXSIZE 4001M
|
|
/
|
|
|
|
spool catalog.log
|
|
@?/rdbms/admin/catalog.sql
|
|
spool off
|
|
|
|
spool catproc.log
|
|
@?/rdbms/admin/catproc.sql
|
|
spool off
|
|
|
|
|
|
--@/u01/app/oracle/bin/full_jvminst.sql
|
|
|
|
|