expdp not consistent
Came across this small oddity that documentation of 10.2 and 11.2 states that expdp by default takes consistent image of the database. But actually it is not so. You need to use flashback_scn/flashback_time for that. Metalink doc 377218.1 explains the scenario. Comments Comment by Chris Fischer on 2011-11-04 19:47:12 +0530 I’ve been warning my customers about this for years. “Shut down all db access before taking a schema or full expdp!” ...