Export/Import and Triggers
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?
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
I agree that the data is the same. But there are a few fields which get database specific values from the before insert triggers.
Try using sql loader. That will allow you to set the database specific values when you load the data.
this space intentionally left blank
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)
Click Here to Expand Forum to Full Width