Records in all_errors, what to do ?
From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/10/31
Message-ID: <DHBHKv.H7G_at_mecati.mecasoft.ch>#1/1
Date: 1995/10/31
Message-ID: <DHBHKv.H7G_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
- INSTALLATION AT A GLANCE --------------------------
ORACLE7 Server (RDBMS) 7.1.6.2.0 TCP/IP Protocol Adapter (V2) 2.1.6.1.0 CORE Version 2.3.7.1.0 Oracle Server Manager 2.1.3.0.0 SQL*Plus 3.1.3.7.1 Oracle Network Manager 2.1.6.0.0 Pro*C 2.0.6.0.0 Multimedia APIs 2.0.5.4.0 PL/SQL V2 2.1.6.2.0 Oracle Help 2.1.1.0.0 SQL*Net V2 2.1.6.1.0 Oracle Office Automation Core 2.1.3.0.0 SQLLIB 1.6.7.0.0 NLSRTL 2.3.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 Oct 31 1995 - 00:00:00 CET