Doubt
Su, May 12, 2020 - 4:51 pm UTC
You mean u r saying, I want disable or drop both constraints n indexes on target?
Should I drop or enable is also fine, if disable after load records I can enable in target.
May 13, 2020 - 12:30 am UTC
- disable constraints
- set indexes to unusable
Then do your load
- rebuild indexes
- enable constraints
I am not a fan of "dropping" things because then you need to remember the exact DDL to recreate them.
Don't forget triggers
A reader, May 13, 2020 - 6:39 am UTC
.. besides indexes and constraints.
Also, do you have LOBS in the concerned table? Assuming it is being carried out in the same DB.
Cheers!
A reader, May 15, 2020 - 12:26 pm UTC
How to do that disable both constraints and indes on target table ?
May 18, 2020 - 2:52 am UTC
alter index IX unusable;
alter table T modify constraint C disable;