Tuesday, March 13, 2018

Synonym

Synonym

Synonym is a pointer.
Recompilation or recreate or replace object types does not invalidate the Synonym. (in 10g and before, it will in 11g and later, it will not )
The synonym will automagically 'fix' itself when referenced, you need to do nothing

select dbms_metadata.get_ddl('SYNONYM','AR_CREDIT_MEMO_LINES','NTX_AR') from dual;



  CREATE OR REPLACE EDITIONABLE SYNONYM "NTX_AR"."AR_CREDIT_MEMO_LINES" FOR "NOE
TIX_SYS"."AR_CREDIT_MEMO_LINES"

    AR_CREDIT_MEMO_LINES - View 
    NOETIX_SYS   - View owner
    NTX_AR       - Private Synonym owner


No comments:

Post a Comment