Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?
share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

I've found an answer to the problem. I put exactly the current timestamp:

flashback_time='2009-06-03 12:05:02'

If I put a sooner timestamp (for instance 5 minutes before) it works perfectly...

share|improve this answer
add comment

Are you certain that the schema you're exporting ('arrels') does not have referential constraints that refer to objects in other schemas? If one or more of the foreign key references in the arrels schema refer to tables in other schemas, then you'll have to export/import them as well.

EDIT: The documentation seems to indicate you need to specify the flashback time in double quotes, e.g.:

'... flashback_time='"2009-06-03 12:00:02"'

Another example I came across was to use the TO_TIMESTAMP function:

exp system/manager file=exp.dmp flashback_time=\"TO_TIMESTAMP('19-06-2004 13:24:26', 'DD-MM-YYYY HH24:MI:SS')\"

Also, you must have automatic undo management enabled to use this.

share|improve this answer
    
Sure, this is not the case. –  FerranB Jun 5 '09 at 19:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.