This discussion is archived
5 Replies Latest reply: Nov 21, 2012 2:28 PM by user9944600 RSS

Missing indexes after export import of different versions

Tom Newbie
Currently Being Moderated
Platform : RHEL 5.4

With original exp/imp utility it was impossible to take the dumpfile of schema from a higher version and import it to a lower version DB. I was glad to discover that this was possible with datapump , maybe only within different patchsets of the same release ( to

Here is the issue
Source schema residing in DB

Target schema  in DB
Using expdp, impdp I managed to import an schema into an DB . All the objects counts match between the source and the target with the exception of few indexes. 7 indexes are missing in the imported schema (in lower version DB)

Anyone faced a similair issue ?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points