No, it should just be "synonym" (metadata, not data). You're not excluding the dba_synonyms data dictionary view, but (private) synonyms as a whole. Public synonyms should still be accessible.
Private synonyms only.Code:1 SELECT OBJECT_PATH, COMMENTS FROM SCHEMA_EXPORT_OBJECTS 2* WHERE OBJECT_PATH LIKE '%SYN%' AND OBJECT_PATH NOT LIKE '%/%' SQL> / OBJECT_PATH ------------------------------------------------------------------ COMMENTS ------------------------------------------------------------------ SYNONYM Private synonyms in the selected schemas




Reply With Quote