Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DROP AND RECREATE ALL INDEXES

675374Mar 23 2009 — edited Nov 16 2011
Hi all,

I have a database with all the tables struture and all their indexes, but no data on the tables.

I have import scripts that will insert millions of rows in the tables.

What i want to do is:

1) built a sript that creates all the indexes
2) drop all the indexes
3) load all the data into the tables
4) create all indexes running the sript 1)

My problem is on point 1). I dont know how to built that script.

Thanks in advance for any help,

RS
This post has been answered by fjfranken on Mar 24 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2011
Added on Mar 23 2009
#general-database-discussions
12 comments
16,181 views