Re: Creating Database - Help Needed
From: Jay Ramadorai <76734.3633_at_CompuServe.COM>
Date: 1995/08/15
Message-ID: <40qa0c$k94$1_at_mhafm.production.compuserve.com>#1/1
Date: 1995/08/15
Message-ID: <40qa0c$k94$1_at_mhafm.production.compuserve.com>#1/1
Steve,
A small CREATE DATABASE should take no longer than half a
minute. 90% of the time is taken up in file allocations in the
OS. The internal sql component takes hardly any time at all.
Dunno too much about VMS but make sure that you system.dbf
(listed in your CREATE DB stmt), your control files (listed in
your config.ora or init.ora) and your redo log files (listed in
your CREATE DB) don't already exist, and there's enough space on
the filesystems for these files.
Hope this helps.
-- Jay Ramadorai Software BuildersReceived on Tue Aug 15 1995 - 00:00:00 CEST
(404) 395-6465 ext108
cserve: 76734, 3633