Disable indexes before imp
833255Feb 1 2011 — edited Feb 1 2011I am importing large tables from a dmp file created by the exp utility. I would like to disable indexes on these tables for the time of import. I tried "alter index ... unusable", but then the imp utility complains, displays the error message that an index is unusable and doesn't do the import.
Do I have to drop indexes? Then my understanding is that I would have to save the SQL statements to recreate these indexes, correct? Or is there a better solution to speed up the import? Some tables have 40 million records.