-
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
-
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'
-
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
-
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."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|