Compile sys views etc

Posted on 2006-04-28
Medium Priority
Last Modified: 2008-02-01
In ORACLE_HOME/rdbms/admin there's a bunch of cat??????.sql(s)
Which of these will recompile system views namely dba_registry?
Question by:xoxomos
  • 2
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16565458
i guess it's the file dba_registry.sql

as I don't have oracle installed here (and hence no doc), difficult to check.

however, you can search for any .sql containing that view name...
LVL 19

Accepted Solution

actonwang earned 1000 total points
ID: 16566830
use catcr.sql

  catcr.sql - CATalog Component Registry

LVL 19

Expert Comment

ID: 16566850
it will create registry related packages , views etc.

Author Comment

ID: 16579685
Running catalog.sql worked also.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question