Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: compile dba_data_files
Perhaps I am missing something obvious here, but what do stats
on dictionary objects have to do with recompiling DBA_DATA_FILES?
Also, the error that Prem is seeing is rather strange, as the view
DBA_DATA_FILES
does not include any reference to obj$, or any other views that do.
FROM clauses for dba_data_files:
8i:
from sys.file$ f, sys.ts$ ts, sys.v$dbfile v
from sys.v$dbfile v, sys.file$ f, sys.x$ktfbhc hc, sys.ts$ ts
10gR1:
from sys.file$ f, sys.ts$ ts, sys.v$dbfile v
from sys.v$dbfile v, sys.file$ f, sys.x$ktfbhc hc, sys.ts$ ts
Jared
On 7/7/05, shirish_at_microexcel.com <shirish_at_microexcel.com> wrote:
>
> 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_at_gmail.com>
> Date: Thu, July 07, 2005 7:38 am
> To: oracle-l <oracle-l_at_freelists.org>
>
> Hi all ,
>
> it's on 9.2.0.6 <http://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
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 07 2005 - 13:05:12 CDT