-
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);
commit;
select * from flash_test;
A B
---- ----------
1 2
10 14
19 22
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);
commit;
on giving the following command
select * from flash_test as of timestamp
to_timestamp('14-jul-09:06:35:25','dd-mon-yy:hh:mi:ss')
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?
Thanks
-
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.
http://www.oracle-developer.net/display.php?id=313
Rgds
Parag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|