Dropping indexes using Before SQL Script

[dougcl]

Hi folks,
I want to drop all the indexes, load the table, and then build all the indexes.

I want to use the oracle Connector before and after SQL scripts to do so.

Does anyone have an example of an oracle script to drop indexes?

Thanks,
Doug

[dougcl]

Hi folks, never mind. I figured it out:

Code: Select all

ALTER TABLE dw_encounters_fact_new 
  DROP CONSTRAINT dw_encounters_fact_new_pk
;
DROP INDEX dw_encounters_fact_new_n01 
;
DROP INDEX dw_encounters_fact_new_n02 
;
DROP INDEX dw_encounters_fact_new_n03
; 
DROP INDEX dw_encounters_fact_new_n04 
;
DROP INDEX dw_encounters_fact_new_n05 
;
DROP INDEX dw_encounters_fact_new_n06 
;
DROP INDEX dw_encounters_fact_new_n07 
;
DROP INDEX dw_encounters_fact_new_n08 
;
DROP INDEX dw_encounters_fact_new_n09
; 
DROP INDEX dw_encounters_fact_new_n10 
;
DROP INDEX dw_encounters_fact_new_n11 
;;