Re: it takes a long time to create a database

Vu Pham wrote:

> Hi all,
>
> Another stupid question :
>
> The whole Oracle installation process took me about 40-45 minutes to install
> 9i ( Enterprise , Management and Client ). This process includes creating a
> database, too.
>
> Then I use dbca to create a sample database with all the default
> configuration paramaters that dbca sets ( with the exception that the data
> file is put in /u02 instead of {$ORACLE_BASE}, and this process took me more
> than 1 hour.
>
> Why dbca takes more time to create an indivual database ? Does it has more
> features ?
>
> Thanks,
>
> Vu

It may depend on the template and what you are creating. Most the time Oracle spends creating a database, unless you are building very large tablespaces, is spent running catalog.sql and catproc.sql.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)