NAVEEN

Sunday, January 17, 2010

Script t o create Database

create database primary
user sys identified by primary
user system identified by primary
maxinstances 1
maxloghistory 1
maxlogfiles 5
maxlogmembers 5
character set US7ASCII
national character set AL16UTF16
datafile 'G:\oracle\product\10.2.0\oradata\primary\system01.dbf' size 200M
extent management LOCAL
SYSAUX datafile 'G:\oracle\product\10.2.0\oradata\primary\sysaux01.dbf' size 200M
DEFAULT TEMPORARY tablespace temp01
tempfile 'G:\oracle\product\10.2.0\oradata\primary\temp01.dbf' size 100M
UNDO tablespace UNDOTBS1
datafile 'G:\oracle\product\10.2.0\oradata\primary\UNDOTBS1.dbf' size 200M
DEFAULT tablespace users
datafile 'G:\oracle\product\10.2.0\oradata\primary\users01.dbf' size 100M
LOGFILE group 1
('G:\oracle\product\10.2.0\oradata\primary\redo01.log') size 10M,
group 2
('G:\oracle\product\10.2.0\oradata\primary\redo02.log') size 10M;

===============control file creation======================================
CREATE CONTROLFILE SET DATABASE "PRIMARY" RESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 32
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO01.LOG' SIZE 10M,
GROUP 2 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\REDO02.LOG' SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\SYSTEM01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\UNDOTBS1.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\SYSAUX01.DBF',
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRIMARY\USERS01.DBF'
CHARACTER SET US7ASCII

No comments:

Post a Comment