An Oracle blog – Amardeep Sidhu

Little bit of fun with Oracle and the related technologies…

expdp not consistent

with 2 comments

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.

Written by Sidhu

November 4th, 2011 at 3:10 pm

Posted in Troubleshooting

Tagged with

2 Responses to 'expdp not consistent'

Subscribe to comments with RSS or TrackBack to 'expdp not consistent'.

  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 [...]

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

    Chris Fischer

    4 Nov 11 at 7:47 pm

Leave a Reply

*
To prove you're a person (not a spam script), type the answer to the math equation shown in the picture. Click on the picture to hear an audio file of the equation.
Click to hear an audio file of the anti-spam equation