Database Software

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!

Data Pump Import not importing indexes

689302Mar 5 2009 — edited Mar 6 2009

According to Oracle's documentation, when doing a full import from a table mode dump file, the import is supposed to pick up the indexes. But I'm running into problems with this. Here are the steps I'm going through.

I export a particular table's partition like so:

expdp / DIRECTORY=data_pump_dir TABLES=schema.table:partiton DUMPFILE=dumpfile.dmp

Then I go in and truncate that table's partition and drop the indexes on the table.

When I run this:

impdp / DIRECTORY=data_pump_dir DUMPFILE=dumpfile.dmp TABLE_EXISTS_ACTION=APPEND

it will import the table data fine, but it will not recreate the indexes.

If I go back through the previous steps, but run this for the import:

impdp / DIRECTORY=data_pump_dir DUMPFILE=dumpfile.dmp TABLE_EXISTS_ACTION=APPEND INCLUDE=INDEX

it will recreate the indexes, but it won't import the data!

Am I missing something here?