export dump

[Roshan]

Hello Erman,

I did a export dump from a schema to another schema on same database

select count(1) from user_indexes   -- 2040 SOURCE (CBS_CORE)

select count(1) from user_indexes   -- 186 TRAGET (MT_UAT_TRG)

As shown above, there is a big difference between  the source and destination

Some indexes were created with compilation errors


Is there a way I can export/import only the indexes?

Grateful if you can help

Regards,

Roshan

[ErmanArslansOracleBlog]

Check with select * from dba_objects where owner='YOUR_SCHEMA' and object_type='INDEX'

[ErmanArslansOracleBlog]

Sorry, you checked ith with user_indexes not all_indexes, that 's okay then.

Did you check the log of the expdp and impdp / exp-imp?

Also, note that: there are some changes in behaviour among the releases.
For example, index lobs is considered differently in 11.2.0.2 and 11.2.0.3

Again check with Check with select * from dba_objects where owner='YOUR_SCHEMA' and object_type='INDEX', also review the exp-imp log files...
There may be some tablespaces missing in the target. If that is so, an index creation can fail if it contains a tablespace tag.


As for your other question,

There is argukment named INCLUDE to do index only import.. (I didn't test it yet)

Here is an example:

impdp username/passowrd INCLUDE="INDEXES,VIEWS"  DUMPFILE=yourfilename.dmp

Check the details with:  impdp help=y