<div>Oracle does supports collecting stats on dict objects</div> <div> </div> <div>but in your case it looks like that you have some issues with obj$</div> <div> </div> <div>does you dba_objects works fine ?</div> <div> </div> <div>better is to do</div> <div> </div> <div>1)analyze the obj$</div> <div>2) if it fails then take a 10046 or </div> <div>3)set a errorstack for 4043 </div> <div> </div> <div>in case obj$ is corrupted then it you need to patch the dict or restore recover from a good known backup .....</div> <div> </div> <div>Regards</div> <div>Shirish</div> <div><BR><BR> </div> <BLOCKQUOTE style="PADDING-LEFT: 8px; MARGIN-LEFT: 8px; BORDER-LEFT: blue 2px solid"><BR>-- ----- Original Message -- -----<BR>Subject: compile dba_data_files<BR>From: Prem <premjhere@(protected)><BR>Date: Thu, July 07, 2005 7:38 am<BR>To: oracle-l <oracle-l@(protected)><BR><BR>Hi all ,<BR><BR>it's on 9.2.0.6. <BR><BR>SQL > desc dba_data_files<BR>ERROR:<BR>ORA-04043 (See ORA-04043.ora-code.com): object dba_data_files does not exist<BR><BR>so one of my friend did a <BR><BR>SQL> alter view dba_data_files compile ;<BR><BR>though it erred out saying "unique key violation in OBJ$" , the next time <BR><BR>SQL > desc dba_data_files<BR><BR>worked .<BR><BR>my question is , can we compile data dictionary views like this ?<BR>OR it is to be avoided strictly ? does oracle support this ?<BR><BR>Please advice.<BR><BR>TIA.<BR>Prem<BR>--<BR>http://www.freelists.org/webpage/oracle-l </BLOCKQUOTE>
