I want to drop all index to improve loading proceses,But i have to upsert medhod because primary key of table is increasing by trigger automatically.
oracle target stage hasnt open/close command.
how can i drop index before ınserting and create after inserting.
Drop Index
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Fri Jun 30, 2006 9:24 am
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia