Re: creating a database

Amit Aggarwal wrote:
>
> Pete Desnoyers wrote:
> >
> > What would be considered the average length of time to create a
> > database? The reason I ask is that I issued the create database command
> > and all the files have been created; however, the command seems to be
> > hanging.
> >
> > Oracle: 7.3.2
> > OS: DEC UNIX 3.2
> >
> > --
> > >>>>>> Pete <<<<<<
> > http://jerry.engrs.infi.net
>
> It depends on how many datafiles you are creating and of what size. On
> an average, a database consisting of 5 datafiles each of 100M would take
> around 15-20 minutes. The command could have hung because of something
> else, which seems to be the case. So just make sure that your create
> database script is OK. and try ruuning it again after dropping the
> database and deleting all the OS files.
>
> amit
> Oracle DBA/Unix SA

Check u r database log mode, if it is archive log mode, try with noarchive log. or give full details for archive log. Received on Wed Sep 24 1997 - 00:00:00 CDT