Re: Time to run Catproc.sql

It happened to me a couple of times (running for more than 2hrs). Now I do a 'set term off' in sqlplus before running the catproc.sql script and don't have this issue. So, you might want to give it a shot.

-Madhu S

judeyjazz_at_hotmail.com (Jude) wrote in message news:<5cdd50fb.0409080213.5fa1898c_at_posting.google.com>...
> 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 - 19:01:12 CDT