CREATE DBgreenspun.com : 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:http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_fi les/installgen_win901_53_.html
You may find the entire list of files helpful on windows: http://www.dotcomsolutionsinc.net/products/installgen/installgen_files _win901.html
or Solaris: http://www.dotcomsolutionsinc.net/products/installgen/installgen_files _sol901.html
I have recently added example files available for building Oracle 9.2.0 databases on Windows: http://www.dotcomsolutionsinc.net/products/installgen/installgen_files _win920.html
David Simpson www.dotcomsolutionsinc.net (Oracle Replication Consulting & Tools)
-- David Simpson (dsimpson@dotcomsolutionsinc.net), September 09, 2002.