Flashback query hitting ORA-01466 even after LAST_DDL_TIME
(Doc ID 2893929.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 21.1 [Release 10.2 to 21.0]Information in this document applies to any platform.
Symptoms
Query table via Flashback query got unexpected ORA-01466 error.
col owner for a20
col object_name for a20
SQL> select owner, object_name,to_char(created,'yyyy-mm-dd hh24:mi:ss') created,to_char(last_ddl_time,'yyyy-mm-dd hh24:mi:ss') last_ddl_time from dba_objects where object_name='T1';
OWNER OBJECT_NAME CREATED LAST_DDL_TIME
-------------------- -------------------- ------------------- -------------------
MAOB T1 2022-08-31 13:06:25 2022-09-01 00:31:38 << got LAST_DDL_TIME
select * from maob.t1 as of timestamp to_timestamp('2022-09-01 04:38:50','YYYY-MM-DD hh24:mi:ss') <
*
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed <<<
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |