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