It can take that long. I find that to be the longest part a lot of time.

Scott D. Adams
Database Administrator

-----Original Message-----
From: Mathews Ansamma
[mailto:oracledba-ezmlmshield-x91242927.[Email address protected]
Sent: Tuesday, October 25, 2005 2:18 PM
To: LazyDBA Discussion
Subject: Catalog.sql taking a long time

We have a 8.1.7 upgraded recently to Oracle 9.2

Looks like there are some problems with some of the dictionary view. Tried
to run catalog.sql and it
seems to be taking too long. It has been running for last 1.5 hrs. How long
it typically takes?




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page