An Oracle blog – Amardeep Sidhu

November 4, 2011

expdp not consistent

Filed under: Troubleshooting — Sidhu @ 3:10 pm

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.


  1. […] comments var addthis_product = 'wpp-261'; var addthis_config = {"data_track_clickback":true};The last post was just like that. It was this GoldenGate issue that woke me up from the deep sleep to do a post […]

    Pingback by OGG-01004 Aborted grouped transaction on ‘, Database error 1403 () at Amardeep Sidhu's Oracle blog — November 4, 2011 @ 4:38 pm | Reply

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

    Comment by Chris Fischer — November 4, 2011 @ 7:47 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Theme: Rubric. Get a free blog at

%d bloggers like this: