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.

2 thoughts on “expdp not consistent

  1. Pingback: OGG-01004 Aborted grouped transaction on ‘, Database error 1403 () at Amardeep Sidhu's Oracle blog

  2. Chris Fischer

    I’ve been warning my customers about this for years. “Shut down all db access before taking a schema or full expdp!”

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *