Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Time to run Catproc.sql
I have recently installed Oracle on my laptop (v 9.2.0.1.0). A
database was created as part of the installation and that seems fine.
However i have since created a new database using scripts as I want to
replicate another database we have. I have run catalog.sql and that
didn't take long but am currently running catproc.sql and it seems to
be taking a very long time. I have tried it once and left it running
for 12 hours and still hadn't finished. On checking the log, however,
I realised that it needed the database to be open as errors were
occuring (mine was started but not mounted). I started it the database
and ran catalog.sql again and started catproc.sql (a couple of hours
ago) and it's still going. Is this normal?? Any suggestions as to why
it could be taking so long would be much appreciated
Cheers
Jude
Received on Wed Sep 08 2004 - 05:13:00 CDT
![]() |
![]() |