DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: How to exclude public synonyms from an Oracle DB Import

Threaded View

  1. #8
    Join Date
    May 2002
    Posts
    2,645
    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.

    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
    Private synonyms only.
    Last edited by stecal; 12-15-2010 at 02:24 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width