INFORMATICA

1) Definir ORACLE_SID
ORACLE_HOME = E:\Oracle\Product\10.0.0
ORACLE_SID = GESTION
2) Crear el fichero INIT.ORA
C:\>ORACLE_HOME\database\initGESTION.ora

control_files =(/path/to/control1.ctl,/path/to/control2.ctl,/path/to/control3.ctl)
undo_management = AUTO
undo_tablespace = UNDOTBS1
db_name = GESTION
db_block_size = 8192
sga_max_size = 1073741824
sga_target = 10737418243) Definir fichero de passwords
$ORACLE_HOME\bin\orapwd file=ORACLE_HOME\database\pwdGESTION.ora password=oracle entries=10
Podemos generar los pasos 2) y 3) con una sola instrucción:
oradim-new -sid GESTION -intpwd -maxusers 20 -startmode auto
-pfile E:\Oracle\Product\10.0.0\Database\initGESTION.ora
4) Arrancar la instancia
C:\>sqlplus / as sysdba
sql> startup nomount
5) Creala base de datos con el nombre(o SID) GESTION y el char set WE8ISO8859P1
CREATE DATABASE GESTION
LOGFILE 'E:\OraData\GESTION\LOG1GESTION.ORA' SIZE 2M,
'E:\OraData\GESTION\LOG2GESTION.ORA' SIZE 2M,'E:\OraData\GESTION\LOG3GESTION.ORA' SIZE 2M,
'E:\OraData\GESTION\LOG4GESTION.ORA' SIZE 2M,
'E:\OraData\GESTION\LOG5GESTION.ORA' SIZE 2M
EXTENT MANAGEMENT LOCAL
MAXDATAFILES 100
DATAFILE'E:\OraData\GESTION\SYS1GESTION.ORA' SIZE 50 M
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'E:\OraData\GESTION\TEMP.ORA' SIZE 50 M
UNDO TABLESPACE undo DATAFILE 'E:\OraData\GESTION\UNDO.ORA' SIZE 50 MNOARCHIVELOG
CHARACTER SET WE8ISO8859P1;
6) Ejecutar sql de creación: catalog.sql y catproc.sql
Sintaxis completa:
CREATE DATABASE nombreDB opciones
Donde las opciones:
DATAFILE filespecAUTOEXTEND OFF
DATAFILE filespec AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]
MAXDATAFILES int
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tablespace [TEMPFILE filespec][EXTENT MANAGEMENT LOCAL] [UNIFORM [SIZE int K | M]]
UNDO TABLESPACE tablespace [DATAFILE filespec]
LOGFILE [GROUP int] filespec
MAXLOGFILES int...