Re: HELP! Records in all_errors, what to do ?

Stefano UNTERNAEHRER (unter_at_mecati.mecasoft.ch) wrote:
: Hi everybody!
 

: I've founded some records in the all_errors view, and don't know if
: 1- this is serious
: 2- how to eliminate this rows (sure not with delete from :-)
 

: select owner, name, type, text
: from all_errors
: order by owner, name, type, text;
 

: Give me this result:

: OWNER NAME TYPE TEXT
: ------- ------------------- ------ -----------------------------------------------
: SYSTEM V_$LOADCSTAT VIEW ORA-01731: circular view definition encountered
: SYSTEM V_$LOADTSTAT VIEW ORA-01731: circular view definition encountered
: SYSTEM V_$NLS_PARAMETERS VIEW ORA-01731: circular view definition encountered
: SYSTEM V_$NLS_VALID_VALUES VIEW ORA-01731: circular view definition encountered
: SYSTEM V_$OPTION VIEW ORA-01731: circular view definition encountered
: SYSTEM V_$PQ_SESSTAT VIEW ORA-01731: circular view definition encountered
: SYSTEM V_$VERSION VIEW ORA-01731: circular view definition encountered
 

: 7 rows selected.

: I will appreciate any help or opinion!
: Thank you,
: Stefano
 

: ------------------------ OUR INSTALLATION AT A GLANCE ------------------------
 
: ORACLE7 Server (RDBMS) 7.1.6.2.0 CORE Version 2.3.7.1.0
: Oracle Server Manager 2.1.3.0.0 Oracle Network Manager 2.1.6.0.0
: SQL*Net V2 2.1.6.1.0 TCP/IP Protocol Adapter (V2) 2.1.6.1.0
: PL/SQL V2 2.1.6.2.0 SQLLIB 1.6.7.0.0
: SQL*Plus 3.1.3.7.1 Pro*C 2.0.6.0.0
: ------------------------------------------------------------------------------
: Stefano Unternaehrer Mecasoft SA
: Oracle DBA 6600 Muralto
: PL/SQL, Pro*C, C, XWindow & Motif Switzerland Europe
: Software Developer fax: +41 91 743 5507
: email: dba,unter_at_mecasoft.ch voice: +41 91 743 7444

You would get this error if you source and target view objects are the same. EG. Select View abc as select * from abc.

--
---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
       ** Different is Not Better. Better is not Different. **
---------------------------------------------------------------------------