Importing DB with index without reindexing

Question

I want to import a DB using impdp. I would like to import the INDEX NAMES and after that, rebuild it manually.

I used the option

EXCLUDE=index

but then I can't find the index in the table all_indexes Is there a way to import the index without build them, and build them manually afterwards ?

Answer 1

Import all tables and data with following parameters

SQLFILE=create_index.sql include=index

This parameter doesn't create any index but create a sql file with all create index sql statements. Using this file you can create index manually after finishing table and data import.