这个错误发生在闪回查询的时候,也可能发生在闪回表的时候
先说结论:如果删除数据后,对表做了ddl操作(更改列的长度等,但是根据测试,增加一列不会报错),然后想闪回,则报错,不能闪回。
实验如下:
SQL> create table gw(id int,name varchar2(5));
Table created.
SQL> insert into gw values(1,'a');
1 row created.
SQL> commit;
Commit complete.
SQL> select sysdate from dual;
SYSDATE
-------------------
2016-11-09 10:15:06
SQL> delete from gw;
1 row deleted.
SQL> commit;
Commit complete.
SQL> select * from gw as of timestamp to_timestamp('2016-11-09 10:15:06','yyyy-mm-dd hh24:mi:ss');
ID NAME
---------- -----
SQL> alter table gw add (sid int);
Table altered.
SQL> select * from gw as of timestamp to_timestamp('2016-11-09 10:15:06','yyyy-mm-dd hh24:mi:ss');
ID NAME SID
---------- ----- ----------
SQL> alter table gw modify name varchar2(10);
Table altered.
SQL> select * from gw as of timestamp to_timestamp('2016-11-09 10:15:06','yyyy-mm-dd hh24:mi:ss');
select * from gw as of timestamp to_timestamp('2016-11-09 10:15:06','yyyy-mm-dd hh24:mi:ss')
ERROR at line 1:
ORA-01466: 无法读取数据 - 表定义已更改
SQL> alter table gw modify name varchar2(5);
Table altered.
SQL> select * from gw as of timestamp to_timestamp('2016-11-09 10:15:06','yyyy-mm-dd hh24:mi:ss');
select * from gw as of timestamp to_timestamp('2016-11-09 10:15:06','yyyy-mm-dd hh24:mi:ss')
ERROR at line 1:
ORA-01466: 无法读取数据 - 表定义已更改
专业墙纸贴纸厨房用具装饰出售,本人网店经营
博客对你有用记得访问下哦,增加下访问量,如有需要可以下单购买哦^_^。https://item.taobao.com/item.htm?id=569617707364