flashbacking truncated table
472273Aug 27 2007 — edited Aug 27 2007hi,
I created a table called "test" with some data and i truncated that table.
After that i used the following "flashback query" to get the truncated data.
SELECT * FROM test
AS OF TIMESTAMP(to_timestamp('27-aug-2007 18:17:08','DD-MON-YY HH24: MI: SS'));
but i am getting the following error.
"ORA-01466: unable to read data - table definition has changed"
is it possible to get back the truncated table?
cheers
RRK