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 (11.2.0.3 to 11.2.0.2).

Here is the issue
Source schema residing in 11.2.0.3 DB

Target schema  in 11.2.0.2 DB
Using expdp, impdp I managed to import an 11.2.0.3 schema into an 11.2.0.2 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 ?

Legend

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