HELP! Records in all_errors, what to do ?

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/11/07
Message-ID: <DHo00y.4o6_at_mecati.mecasoft.ch>#1/1


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
Received on Tue Nov 07 1995 - 00:00:00 CET

Original text of this message