Thursday, April 28, 2011

Example fo create database script.

Hi

        Find the example of create a database in oracle.

             create database shiva
             logfile group 1 ('D:\log\log1a.log','D:\log\log1b') size 10m,
             group 2 ('D:\log\log2a.log','D:\log\log2b') size 10m
             maxlogfiles 3
             maxlogmembers 3
             maxinstances 1
             maxdatafiles 100
             maxloghistory 100
             datafile 'D:\dat\sysdata.dbf' size 200m
             undo tablespace undo1 datafile 'D:\dat\undo1.dbf'size 100m
             default temporary tablespace temp1 tempfile 'D:\dat\temp1.dbf'size 100m;

No comments:

Post a Comment