Thursday, April 12, 2012
6:21 PM

create a database manually IN CMD mode

1) I connect on sqlplus using the command: sqlplus / as sysdba
2) SQL>@ create_db.sql

SQL scrip "create_db.sql":

CREATE DATABASE VENKAT
MAXLOGFILES 3
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXLOGHISTORY 0
LOGFILE GROUP 1
('/u01/venkat/origlog/redo_g1m1.log','/u01/venkat/mirrorlog/redo_g1m2.log') SIZE 10 M,
GROUP 2
('/u01/venkat/origlog/redo_g2m1.log','/u01/venkat/mirrorlog/redo_g2m2.log') SIZE 10 M,
GROUP 3
('/u01/venkat/origlog/redo_g3m1.log','/u01/venkat/mirrorlog/redo_g3m2.log') SIZE 10 M,
DATAFILE '/u01/venkat/data1/system.dbf' SIZE 300 M,
DATAFILE '/u01/venkat/data1/undo_tbs.dbf' SIZE 500 M,
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/u01/venkat/data1/temp01.dbf' SIZE 500 M,
CHARACTER SET WE8ISO8859P1;

0 comments:

Post a Comment