Re: Database Creation in Windows (9i)

From: Shahnaz <ahamedshahnaz_at_gmail.com>
Date: 26 May 2006 23:14:59 -0700
Message-ID: <1148710499.600843.262740@g10g2000cwb.googlegroups.com>

Is it possible to specify only tablespace without specifying datafile? i can see from your script says

default temporary tablespace temp.....

please replace the above line like below

default temporary tablespace temp tempfile 'c:\.........xyz.dbf' 100m

as well as try to put the line

DATAFILE 'C:\ORACLE\ORADATA\ADLEY\SYSTEM.DBF' SIZE 300M in the begining like

create database adley DATAFILE 'C:\ORACLE\ORADATA\ADLEY\SYSTEM.DBF' SIZE 300M FYI, iam started learning oracle DBA ;-)

Shahnaz Received on Sat May 27 2006 - 01:14:59 CDT