Re: compile dba_data_files
- From: Jared Still <jkstill@xxxxxxxxx>
- To: shirish@xxxxxxxxxxxxxx
- Date: Thu, 7 Jul 2005 11:02:40 -0700
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@xxxxxxxxxxxxxx <shirish@xxxxxxxxxxxxxx> 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@xxxxxxxxx>
> Date: Thu, July 07, 2005 7:38 am
> To: oracle-l <oracle-l@xxxxxxxxxxxxx>
>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
> -- //www.freelists.org/webpage/oracle-l
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
