ORA-01466: unable to read data - table definition has changed
来源:互联网 发布:中国软件与即时 编辑:程序博客网 时间:2024/05/01 10:47
1. Oracle建议我们等待大约5分钟之后再进行flashback query新创建的表,否则可能会碰到这个错误ORA-01466: unable to read data - table definition has changed. 注意这个5分钟时间间隔正好是9i 中SCN和timestamp相map的时间间隔,虽然可以用timestamp来进行flashback query,但实质还是根据该timestamp对应的SCN来进行flasbback query, 由于timestamp不是实时地跟SCN对应上, 因此我们需要等段时间来让timestamp跟SCN同步上, 因此用SCN会比timestamp更准确些。注意SCN会在每个commit的时候增长。
2. 在创建好表之后,最好等几分钟让SCN增加。如果尝试去flashback一个新创建的表,可能会遇到ORA-01466: unable to read data - table definition has changed
SQL> create table fbt
2 ( x integer,
3 y timestamp,
4 z varchar2(30));
Table created.
SQL> exec dbms_lock.sleep(10);
PL/SQL procedure successfully completed.
SQL> insert into fbt values(1, LOCALTIMESTAMP, 'Initial population');
1 row created.
SQL> commit;
Commit complete.
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- ORA-01466: unable to read data - table definition has changed
- the data that is in the table is from excel, so the data to be read can changed?
- Unable to read additional data from client sessionid 0x0, likely client has closed socket
- DBSPI40-1: Unable to fetch data from table 'V$SYSSTAT' [ORA-03135: connection lost contact]
- ORA-01653: unable to extend table
- ORA-01653: unable to extend table
- ORA-01653: unable to extend table
- MySQL+VBB问题:Record has changed since last read in table 'session' 的解决
- CE Unable to read data from the transport connection.
- Unable to read additional data from client sessionid
- ORACLE ORA-01653: unable to extend table 的错误
- ORACLE ORA-01653: unable to extend table 的错误
- ORA-31633: unable to create master table "NEW.GWJOB"
- ORA-31633: unable to create master table "SCOTT.JOB2"
- ORACLE ORA-01653: unable to extend table 的错误
- ssh免登陆设置后,还是要输入密码
- Stack Overflow Questions Tags Users Badges Unanswered Ask Question ruby
- MATLAB中文件的读写和数据的导入导出
- 如何管理二十八类型的员工
- swift笔记
- ORA-01466: unable to read data - table definition has changed
- 第三讲:关系数据库模型
- 关于ubuntu下的c++编译
- 优秀的Unix系统管理员的7个习惯
- iOS技巧之获取本机通讯录中的内容,解析通讯录源代码
- 【美妙的Python之四】变量:数字、字符串
- Hadoop基本文件命令
- android中的数据库操作
- 在HTML文档中嵌入CSS的几种方式