flashback table error
Hi,Not sure I chose the right place or not for flash table errors. if not please help move it to the appropriate one.
I am having flashback table errors on 11.2.0.2. Archivelog is on. db_flashback_retention_target = 1440, undo_retention = 900
CREATE TABLE t (c1 NUMBER(6)) ENABLE ROW MOVEMENT;
CREATE RESTORE POINT before_we_do_anything;
INSERT INTO t VALUES (1);
COMMIT;
SELECT c1,ORA_ROWSCN,SCN_TO_TIMESTAMP(ORA_ROWSCN) FROM t WHERE c1 = 1;
C1 ORA_ROWSCN SCN_TO_TIMESTAMP(ORA_ROWSCN)
1 46671641 03/28/2012 09:05:29
SELECT * FROM t AS OF SCN 46671641 WHERE c1 = 1;
ORA-01466: unable to read data - table definition has changed
how can I get rid of this error?
I am having flashback table errors on 11.2.0.2. Archivelog is on. db_flashback_retention_target = 1440, undo_retention = 900
CREATE TABLE t (c1 NUMBER(6)) ENABLE ROW MOVEMENT;
CREATE RESTORE POINT before_we_do_anything;
INSERT INTO t VALUES (1);
COMMIT;
SELECT c1,ORA_ROWSCN,SCN_TO_TIMESTAMP(ORA_ROWSCN) FROM t WHERE c1 = 1;
C1 ORA_ROWSCN SCN_TO_TIMESTAMP(ORA_ROWSCN)
1 46671641 03/28/2012 09:05:29
SELECT * FROM t AS OF SCN 46671641 WHERE c1 = 1;
ORA-01466: unable to read data - table definition has changed
how can I get rid of this error?
0