ORA-08189: cannot flashback the table because row movement is not enabled
来源:互联网 发布:java转十六进制 内存 编辑:程序博客网 时间:2024/06/05 09:42
SQL> flashback table fb_table to timestamp
2 to_date('2014-05-17 15:25:44','yyyy-mm-dd hh24:mi:ss');
flashback table fb_table to timestamp
*
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled
启用表允许行移动
alter table fb_table enable row movement;
Table altered.
SQL> select table_name,row_movement from user_tables
2 where table_name='FB_TABLE';
TABLE_NAME ROW_MOVE
------------------------------ --------
FB_TABLE ENABLED
SQL> flashback table fb_table to timestamp to_date('2014-05-17 15:41:01',
2 'yyyy-mm-dd hh24:mi:ss');
Flashback complete.
0 0
- 闪回命令出错 ORA-08189: cannot flashback the table because row movement is not enabled
- ORA-08189: cannot flashback the table because row movement is not enabled
- ORA-08189: cannot flashback the table because row movement is not enabled
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-01618: redo thread 2 is not enabled - cannot mount
- ORA-01618: redo thread 2 is not enabled - cannot mount
- Visual Studio cannot debug managed applications because a kernel debugger is enabled on the system
- The service cannot be started, either because it is disabled or because it has no enabled deices ass
- proxool的一个问题 but the last SQL it performed is unknown because the trace property is not enabled
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount 错误
- ORA-01618: redo thread 2 is not enabled - cannot mount RAC
- ORA-38709: Recovery Area is not enabled.
- Error: Debugging Failed Because Integrated Windows Authentication Is Not Enabled
- Debugging failed because integrated Windows authentication is not enabled
- Debugging Failed Because Integrated Windows Authentication Is Not Enabled
- 讨论i++和++i
- dojo 的EnhancedGrid插件
- 手机定位到底该用在哪里呢?
- 使用 PHP 和 Ajax 的 XML 编程
- 在Python中处理中文路径
- ORA-08189: cannot flashback the table because row movement is not enabled
- Oracle10g新特性――增强的CONNECT BY子句
- UI小组件学习
- Cocos2D-X2.2.3学习笔记10(几何图形)
- 活着很累,却是一种无怨无悔
- Java程序员学习之路(书籍)
- OLAP之全过程介绍
- weyeuryikyupui[
- 我的第一篇博客