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 ?

Do a second import for just the indexes afterwards? Why do you want to do this though? — Alex Poole, Jan 22 '18 at 10:38

score 2 · Accepted Answer · answered Jan 22 '18 at 14:55

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.

Ramki · Answer 2 · 2018-02-06T09:05:48.143

0

you can also export/ import only metadata, this will import only table & index structures.

CONTENT=metadata_only

edited Feb 06 '18 at 09:05

answered Feb 06 '18 at 08:44

Ramki

453
2
7

Importing DB with index without reindexing

2 Answers2