Hi and thank to all in advance!
Iīm new in this forum, so ...
I need to know how to recover a table which has change in the table definition. I explain my situation with an example:
1.- I drop a colum in the table
alter table test1 drop column c;
2.- I need to comeback in the time to recovery the before state, but not with a import.
In first time i thought to set a recovery point with:
CREATE RESTORE POINT uno;
And then (after the alter table) recovery the table to that point with:
FLASHBACK TABLE test1 TO RESTORE POINT uno;
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed
Someone could to say me how to solve thar problem?