Export/Import and Triggers
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export/Import and Triggers

  1. #1
    Join Date
    Sep 2005
    Posts
    6

    Export/Import and Triggers

    Hi,

    I am looking to transfer the data from one database to another, both having the same structure.
    Which mechanism should be used so that the before insert triggers get triggered and act on the data, before it is inserted?
    Can this be achieved through export/import?

    Thanks.

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    User_object like packages and triggers will be imported after all tables has been imported using sql>imp user/user@your_db.

    What is the reason for the action on tables during import if its the same data?

    If you import object first, it will be in a uncompiled/disbaled state without the table reference.
    Able was I ere I saw Elba

  3. #3
    Join Date
    Sep 2005
    Posts
    6
    I agree that the data is the same. But there are a few fields which get database specific values from the before insert triggers.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Try using sql loader. That will allow you to set the database specific values when you load the data.
    this space intentionally left blank

  5. #5
    Join Date
    Oct 2005
    Posts
    10
    As far as I understand you already have tables and triggers on the other database. So import conventional (not direct) and set parameter IGNORE=Y (import would ignore errors like table exists)

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