Sunday, May 25, 2008

CREATE DATABASE MANUALLY

CREATE DATABASE
USER SYS IDENTIFIED BY
USER SYSTEM IDENTIFIED BY
CONTROLFILE REUSE
MAXDATAFILES
MAXINSTANCES
CHARACTER SET
NATIONAL CHARACTER SET
SET DEFAULT TABLESPACE
LOGFILE GROUP ,
[GROUP ,]
[GROUP ]
MAXLOGFILES
MAXLOGMEMBERS
MAXLOGHISTORY

[FORCE LOGGING]
EXTENT MANAGEMENT LOCAL
DATAFILE
SYSAUX DATAFILE
DEFAULT TABLESPACE
DATAFILE
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE
DEFAULT TEMPORARY TABLESPACE

TEMPFILE
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE SIZE
UNDO TABLESPACE
DATAFILE
SET TIME_ZONE = ;

No comments: