How to export and import public synonyms?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to export and import public synonyms?

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    4

    Question

    I want to export and import only public synonyms in a database. Is it possible?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    AFAIK its not possible to export and import just the synonyms.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Yes, AFAIK it is not possible : EXP can be used to export only tables, or only grants, or only indexes, BUT it donīt give to us an option to export only synonyms.
    The best way to "pass" only the synonyms to another db is to create a scrit with the necessary CREATE SYNONYM in sql*plus, selecting the data from DBA_SYNONYMS or ALL_SYNONYMS, as desired.
    Another option (not preferred due to mount of work) is extract the CREATE SYNONYMS from an exported file.

    Regards,

    Chiappa

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