I'm trying to obtain a consistent export (with data pump) from an schema emulating the CONSISTENT=Y
. Currently I'm executing data pumb in this way:
'/ AS SYSDBA' schemas=arrels dumpfile=arrels.dmp nologfile=y flashback_time='2009-06-03 12:00:02'
But when importing shows errors about inconsistency:
ORA-02298: cannot enable name - parent keys not found
If the data pump export are working with flashback_time
and, of course, the constraints are validated on export time:
- Why this is happening?
- Any suggestion to solve it?