This content has been marked as final. Show 2 replies
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.