exp with flashback
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: exp with flashback

  1. #1
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97

    exp with flashback

    Hi all,

    IŽam trying to export a table (where some body droped some data today) with the state from yesterday.

    c:\> exp abc/123 full=y file=yesterday.dmp flashback_time='17.12.03'

    The result is an Ora-08180 error, saying there is no snapshot for this point of time in sys.dbms_flashback.

    I set the undo_retention parameter to 86400. - I thought that means 24 hours.

    if I try the same procedure with flashback_time='18.12.03' I got the same problem.

    What am I doing wrong?

    Pleas help!

    Christian

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You may not be doing anything wrong. One limitation of FlashBack is that you must have enough temporary(UNDO) storage to hold the information. If you UNDO tablespace is too small, it will purge the oldest data until it has enough space.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    So for the future, I have to make the UNDO TBS bigger

    Is there any formular for the size of the UNDO TBS to prevent such problems?

    but the data are lost anyway, I fear. So we learn ...

    Thank you for your answer!

    Christian

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: exp with flashback

    Originally posted by ckiltz
    Hi all,

    IŽam trying to export a table (where some body droped some data today) with the state from yesterday.

    c:\> exp abc/123 full=y file=yesterday.dmp flashback_time='17.12.03'

    The result is an Ora-08180 error, saying there is no snapshot for this point of time in sys.dbms_flashback.

    I set the undo_retention parameter to 86400. - I thought that means 24 hours.

    if I try the same procedure with flashback_time='18.12.03' I got the same problem.

    What am I doing wrong?

    Pleas help!

    Christian
    Try giving the time as well. The flashback_time depends on the value specified for UNDO_RETENTION and the size of the undo tablespace.

    For more details refer to metalink note 204334.1
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width