Re: import dump

Posted by ErmanArslansOracleBlog on Dec 14, 2016; 8:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-dump-tp1732p1743.html

Roshan,

I don't see any index creation errors in your import log file.

Are you doing a full export-import? ( I only see LCSM_PROD schema objects in your import log file). So the missing indexes may be owned by other schemas which are not exported or imported? You are importing the the objects from LCSM_UAT schema to LCSM_PROD, so maybe those indexes belong to different schemas?
(In other words, Are you sure that those indexes are exported in the first place?)
What are the indexes that are missing in the target? Make a comparison on dba_indexes between source and target to find those 10 missing indexes? (what are their owner, what are their names, what is their creation time in the source on an so on..)