ORA-01775 Querying Dba_waiters

Today arrived an alarm about locks in the database, when we run the following query to gather more information.

 

CLOUD*ANTO> select * from dba_waiters;

 

I get the following error

 

select * from dba_waiters
*
ERROR en línea 1:
ORA-01775: looping chain of synonyms

 

 

Looking at the definition of the synonym to discarding errors;

 

CLOUD*ANTO> SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME=’DBA_WAITERS’;

OWNER            TABLE_OWNER   TABLE_NAME
___________ _____________ ____________
PUBLIC             SYS                          DBA_WAITERS

 

Reviewing the table from sqlplus as sysdba;

 

SQL> select * from sys.dba_waiters;
select * from sys.dba_waiters
*
ERROR at line 1:
ORA-00942: table or view does not exist

 

It seems that the table is not created or was created and delete at the time, the solution is recreating these objects by the run the following script.

 

$ORACLE_HOME/rdbms/admin/catblock.sql

 

HTH – Antonio NAVARRO

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s