Re: export dump

Posted by ErmanArslansOracleBlog on Feb 24, 2017; 6:34am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/export-dump-tp2204p2207.html

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