export dump

Posted by Roshan on Feb 23, 2017; 3:05pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/export-dump-tp2204.html

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