5 Replies Latest reply: Nov 21, 2012 4:28 PM by user9944600 RSS

    Missing indexes after export import of different versions

    Tom
      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 ?