-
Mar03
10g logmnr 无法挖掘DML的解决
Posted in Database, 775 views
-
Oracle 10g的logmnr做了一些改变，在默认状态下，无法挖掘到如delete、insert、update这样的DML语句，而当我们误删数据的时候，正需要用logmnr挖掘DML来进行恢复。
Oracle提供了一条语句来开启logmnr对DML的支持
alter database add supplemental log data (primary key, unique index) columns;
Related posts:
Categories
Recent
Comments
- 哈哈，早说你碰到这个问题了我告诉你嘛
- 把用户帐号启用...
- on 查询一天归档文件的大小很详细的代码，多谢共享！
- 很好的工具，多谢！
- 我的问题是：Error: Access Denied, user account disabled....
Archives
- August 2010
- July 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- July 2009
- June 2009
- May 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
Leave a comment | Trackback 这篇文章有2个评论.
1F 缘维
2009-07-12 9:11 pm
本来不想说了,可是我实在是看不习惯这样的做法,你自己点击看一下你的友情链接”久久读书人”是不是会弹出一个网站覆盖你的博客….我也和他交换了链接,我把它给取消了…不喜欢这样的做法.
2F skywalker
2009-07-13 9:15 am
这个问题把超链接目标改成_blank就可以了，我之前也没有注意，多谢提醒