DBA_SYNONYMS needs modification

greenspun.com : LUSENET : DBAzine : One Thread

Hi dbaZine,

Why does dba_synonyms look like this, considering that synonyms can be for various object types, not just tables?

SQL> desc dba_synonyms Name Null? Type ----------------------------------------- -------- -------------------- OWNER NOT NULL VARCHAR2(30) SYNONYM_NAME NOT NULL VARCHAR2(30) TABLE_OWNER VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) DB_LINK VARCHAR2(128)

Wouldn't it make more sense to have something like this?:

SQL> desc what_dba_synonyms_should_look_like Name Null? Type ----------------------------------------- -------- -------------------- OWNER NOT NULL VARCHAR2(30) SYNONYM_NAME NOT NULL VARCHAR2(30) OBJECT_OWNER VARCHAR2(30) OBJECT_NAME NOT NULL VARCHAR2(30) OBJECT_TYPE DB_LINK VARCHAR2(128)

-- gordon banner (gordon.banner@the401k.com), December 13, 2002


Moderation questions? read the FAQ