CREATE DB : LUSENET : DBAzine : One Thread

Hi All I tried to create small DB in 9.0 to try something on it but unable to do that if you DBAs can help me here...

SQL> startup nomount pfile= c:\test\admin\pfile\init.ora; ORACLE instance started.

Total System Global Area 118255568 bytes Fixed Size 282576 bytes Variable Size 83886080 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes

SQL> create database prod3 2 controlfile reuse 3 datafile 'c:\test\oradata\system01.dbf' size 325m 4 default temporary tablespace tempts1 5 logfile group 1 ('c:\test\oradata\redo01.log') size 100m, 6 group 2 ('c:\test\oradata\redo02.log') size 100m, 7 group 3 ('c:\test\oradata\redo03.log') size 100m; create database prod3

-- FIZA (SFIZA15@HOTMAIL.COM), August 01, 2002


Fiza, Here is a script on my website which could help you with creating an Oracle 9i database on Windows: les/installgen_win901_53_.html

You may find the entire list of files helpful on windows: _win901.html

or Solaris: _sol901.html

I have recently added example files available for building Oracle 9.2.0 databases on Windows: _win920.html

David Simpson (Oracle Replication Consulting & Tools)

-- David Simpson (, September 09, 2002.

Moderation questions? read the FAQ