Results 1 to 4 of 4

Thread: export/import

  1. #1
    Join Date
    Jul 2005

    Unanswered: export/import

    I have a question on export / Import.
    When I'm exporting data from one schema(dev) to other(test), does synonyms also get exported? What if the synonyms already exist in test, will they be recreated?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    The proof is in the pudding.
    Do the import & examine the results.
    Post what you've learned.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2005
    The synonyms which exist wont get copied again.

    IMP-00015: following statement failed because the object already exists:
    "CREATE SYNONYM "tab1" FOR "SYSADM"."tab1""

  4. #4
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    This goes for everything, not only synonyms. Objects that exist (and are not created OR REPLACED (like procedures, triggers, packages) will not be created during import. You might want to read more about the IGNORE=Y parameter of the IMP command.

Posting Permissions

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