Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> compile dba_data_files

compile dba_data_files

From: Prem <premjhere_at_gmail.com>
Date: Thu, 7 Jul 2005 17:08:26 +0530
Message-ID: <56d3d56105070704381f03d544@mail.gmail.com>


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
Received on Thu Jul 07 2005 - 06:40:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US