exp with flashback

[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

[jrpm]

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.

[ckiltz]

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

[adewri]

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