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

    Missing indexes after export import of different versions

      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 ?