RE: compile dba_data_files

Hi... 

 AFAIK stats on dictionary objects are supported in 10g. 
 
 I would consider rerunning (as sys) the catalog.sql to correct dba_data_files 
view. 

 That is much safer approach, IMHO.

Cheers!

- Kirti 


--- shirish@xxxxxxxxxxxxxx wrote:


---------------------------------
Oracle does supports collecting stats on dict objects
 
but in your case it looks like that you have some issues withobj$
 
does you dba_objects works fine ?
 
better is to do
 
1)analyze the obj$
2) if it fails then take a 10046 or 
3)set a errorstack for 4043 
 
in case obj$ is corrupted then it you need to patch the dict orrestore recover 
from a
good known backup .....
 
Regards
Shirish


 

-------- Original Message --------
Subject:compile dba_data_files
From: Prem<premjhere@xxxxxxxxx>
Date: Thu, July 07, 2005 7:38 am
To:oracle-l <oracle-l@xxxxxxxxxxxxx>

Hi all ,

it's on9.2.0.6. 

SQL > desc dba_data_files
ERROR:
ORA-04043:object dba_data_files does not exist

so one of my friend did a

SQL> alter view dba_data_files compile ;

though iterred out saying "unique key violation in OBJ$" , the next time

SQL > desc dba_data_files

worked .

my questionis , can we compile data dictionary views like this ?
OR it is to beavoided strictly ? does oracle support this ?

Pleaseadvice.

TIA.
Prem
--
http://www.freelists.org/webpage/oracle-l--http://www.freelists.org/webpage/oracle-l



                
____________________________________________________
Sell on Yahoo! Auctions ? no fees. Bid on great items.  
http://auctions.yahoo.com/
--
http://www.freelists.org/webpage/oracle-l

Other related posts: