Oracle does supports collecting stats on dict objects
but in your case it looks like that you have some issues with
obj$
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 or
restore recover from a good known backup .....
Regards
Shirish
-------- Original Message --------
Subject:
compile dba_data_files
From: Prem
<premjhere@gmail.com>
Date: Thu, July 07, 2005 7:38 am
To:
oracle-l <oracle-l@freelists.org>
Hi all ,
it's on
9.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 it
erred out saying "unique key violation in OBJ$" , the next time
SQL > desc dba_data_files
worked .
my question
is , can we compile data dictionary views like this ?
OR it is to be
avoided strictly ? does oracle support this ?
Please
advice.
TIA.
Prem
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 07 2005 - 12:32:32 CDT
