Dear DBA Friends,
DB Version - 11.2.0.4.
I'm migrating a DB from AIX - Linux and as part of the initial load, exporting/importing some schemas using Oracle data pump (expdp/impdp).
The app that runs on the DB is Oracle Web center Sites (There are schemas like - SEARCHSYS, WP2_OCS... that have unstructured data... Oracle Text index tabales in specific (DR$... IOT's).
Some DR$ tables export/import fine, but others are missing rows. Less rows in target than in source mostly. A couple of cases where I have more rows in target too... Just under these 2 schemas and for DR$ tables only.
Is this a known behavior? I read somewhere this may be normal due to Index fragmentation etc.. that target will have less rows.
Anyone any experience? Appreciate your inputs.
Thanks