This content has been marked as final. Show 2 replies
Hi, you will must find the trigger and constraint and disable manually. Find the triggers on DBA_TRIGGERS and DBA_CONSTRAINTS, and disable to them manually. Also you can use SQL Developer for make that with GUI.
Have a good day.
Is this target table already loaded in your database?
I figure out, even though you don't explicitly mention it, it comes from a regular export file, isn' it?
You should first verify it there is an already associated trigger with it, if this is the case, you should temporarily disable by issuing this command:
ALTER TRIGGER <trigger_name> DISABLE; -- to disable an specific trigger
ALTER TABLE <table_name> DISABLE ALL TRIGGERS; -- to disable all associated trg.
In case the table already exists.
On the constraints issue, you should disable them in case table already exists.
ALTER TABLE <table_name> DISABLE PRIMARY KEY; -- or any other constraint.
If table doesn't exist and you don't want to import constraints along the table specify the CONSTRAINTS=N at import time.