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