flash back query and timestamp problem
I have given the following
create table flash_test(a number(3) primary key,b number(3));
insert into flash_test values(1,2);
insert into flash_test values(10,14);
insert into flash_test values(19,22);
select * from flash_test;
now the time and date is 14-jul-09:06:35:25
after 5 minites
insert into flash_test values(31,34);
insert into flash_test values(35,37);
on giving the following command
select * from flash_test as of timestamp
ORA-01466: unable to read data - table definition has changed
why plz suggest?
well the table definition changed - nothing you can do
But i have not changed the definition.
I gave the the steps exactly what i have written previously?
How this has happend?
2 things i can think of..
1) Flash back needs ROW MOVEMENT enabled on table
so either create your table with row movement enabled or alter it after creating
CREATE TABLE flash_test ENABLE ROW MOVEMENT(a number(3) primary key,b number(3));
just check the syntax else you can alter it after normal creation.
alter TABLE flash_test ENABLE ROW MOVEMENT;
2) I read somewhere that you have to wait till SCN advances for to do flashback else you will get error as u got.
Having created our table, we should wait a few minutes to allow the SCN to advance. Attempting to flashback a new table straight away can result in ORA-01466: unable to read data - table definition has changed.
Click Here to Expand Forum to Full Width