compile dba_data_files 2005-07-07 - By Kirtikumar Deshpande
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@(protected) 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@(protected)>
Date: Thu, July 07, 2005 7:38 am
To:oracle-l <oracle-l@(protected)>
Hi all ,
it's on9.2.0.6.
SQL > desc dba_data_files
ERROR:
ORA-04043 (See ORA-04043.ora-code.com):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
|
|
