Does anyone have SQL which will auto-generate CREATE INDEX DDL using SQL's Catalog as it's data source?
(I do NOT want to manually create the DDL using Enterprise Manager generate sql script)
I have the need to DROP Indexes prior to loading large volumes of data. Then, dynamically recreating the IDX's using the DDL rendered in step 1 above.
-thx
(I do NOT want to manually create the DDL using Enterprise Manager generate sql script)
I have the need to DROP Indexes prior to loading large volumes of data. Then, dynamically recreating the IDX's using the DDL rendered in step 1 above.
-thx
