TruncateTable PAT01 and PAT03

[MaurizioAG]

Dear Sap,

I truncate the table PAT01 and PAT03, i would like to know if is possible restore it.

With the command FLASHBACK TABLE i get two different error message:

1) with timestamp from 1 to 5 days ago

ORA-01466: unable to read data - table definition has changed

2) with timestamp more than 6 days ago

ORA-08180: no snapshot found based on specified time

Could you help me.

Best Regards and Thanks in advance

Massimo Tamagno

[Former Member]

yes you can restore the tables

FLASHBACK TABLE sapr3.pat01, sapr3.pat03 TO TIMESTAMP (MAR-29-2000, 16:00:00);

change the timestamp according to the time u truncated

change the schema <sapr3> as mentioned in your system.

Edited by: Shaji Jacob on Mar 29, 2008 5:02 PM

[MaurizioAG]

Hi Jacob,

I did, but i got error on the syntax (MAR-29-2008, 19:10:00) in timestamp

FLASHBACK TABLE SAPSR3.PAT03 TO TIMESTAMP (MAR-29-2008, 19:10:00);

SP2-0552: Bind variable "10" not declared.

Thanks,

Massimo Tamagno

[Former Member]

Try this, correct the syntax where required pls

FLASHBACK TABLE SAPSR3.PAT03 TO TIMESTAMP ('MAR-29-2008, 19:10:00', 'MON-DD-YYYY, HH24:MI:SS');

or

FLASHBACK TABLE SAPSR3.PAT03 TO TIMESTAMP ('MAR-29-2008 19:10:00' 'MON-DD-YYYY HH24:MI:SS');

or

FLASHBACK TABLE SAPSR3.PAT03 TO TIMESTAMP ('MAR-29-2008 19:10:00', 'MON-DD-YYYY HH24:MI:SS');

or

FLASHBACK TABLE SAPSR3.PAT03 TO TIMESTAMP

TO_TIMESTAMP('MAR-29-2008 19:10:00 PM');

Check out on the syntax please

Edited by: Shaji Jacob on Mar 29, 2008 6:34 PM