Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Time to run Catproc.sql

Time to run Catproc.sql

From: Jude <judeyjazz_at_hotmail.com>
Date: 8 Sep 2004 03:13:00 -0700
Message-ID: <5cdd50fb.0409080213.5fa1898c@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 - 05:13:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US