ORA-38301:can not perform DDL/DML Over Object in Recycle Bin 11.2.0.4
我们最近有两台测试服务器在oci direct load期间出现下列异常:
从表象上看,是我们在对表执行ddl操作,确实内部也是用了truncate table XXX,可是这个XXX并不是回收站里面的XXX。即使是purge dba_recyclebin之后,也可能还是会有这个问题,所以这个问题只能说和回收站有关、但是并不一定是该表本身被DDL的原因。目前已知除了直接对回收站中的表直接DDL之外(这一般用户不会直接进行,但是oracle后台的各种自身统计收集任务是允许这么做的),有可能是表空间中存在一些回收站,导致了XXX表和该表空间中已回收的对象存在空间争用(但是我看下了dba_data_files,可用空间是足够的);还有一个可能的已知原因是auto space advisor任务在跑。
前者可以通过下列语句清理:
purge tablespace XXX;
后者可以通过下列方式禁用:
begin dbms_auto_task_admin.disable(client_name => 'auto space advisor', operation => null, window_name => null); end; /
伴随着ORA-38301,通常在alert.log里面会有日志:performing DML/DDL operation over object in bin. 但是他没有被当做ERROR或者WARNING来显示和对待。
我们的错误重放过程和https://knowledge.exlibrisgroup.com/Aleph/Knowledge_Articles/Oracle_message_in_alert_log%3A__%22performing_DMLDDL_operation_over_object_in_bin%22非常像,但是模拟不出来,有很多的帖子去模拟,比如http://www.xifenfei.com/2011/07/performing-dmlddl-operation-over-object-in-bin%E9%94%99%E8%AF%AF%E6%A8%A1%E6%8B%9F.html,实际上业务根本不是这么操作的,所以这些所谓的专家就是这么忽悠的,通常就是为了凑而凑。
至于ORA-39776,它纯粹是表象,需要看具体的cause。
参考:
https://blog.csdn.net/lansesl2008/article/details/16116749
http://zy8643954.iteye.com/blog/701831
相关文章
- 解决python编码问题报错:'ascii' codec can't encode characters in position 0-15: ordinal not in range(128)
- How To: Configure MachineKey in ASP.NET 2.0
- Execution Plans in SQL Server
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- Elements in iteration expect to have 'v-bind:key' directives
- download file by python in google colab
- Types of Entity in Entity Framework:
- 解决问题“The App ID ‘XXXXX‘ appears to be in use by the App Store, so it can not be removed at this ti”
- 鲁棒性、过敏感性、过稳定性、in-domain、out-domain、open-domain
- P2转P3时出现‘utf-8‘ codec can‘t decode byte 0xb3 in position 0: invalid start byte(x、decode解码)
- UnicodeDecodeError gbk codec can't decode byte in position illegal multibyte sequence
- 关于微信小程序警告“Do not have handler in component: pages/xxx/xxx. “的解决方法
- JavaScript Module Pattern: In-Depth
- [Vue warn]: Error in mounted hook: "Error: please transfer a valid prop path to form item!"
- sockaddr & sockaddr_in struct
- Swift - whose view is not in the window hierarchy 问题解决方法
- 大数据学习——Linux-SSH报错:Could not resolve hostname centos02: Temporary failure in name resolution
- Using JavaScript with WKWebView in iOS 8
- UnicodeDecodeError: 'ascii' codec can't decode byte 0xa0 in position 0: ordinal not in range(128)
- SQL Server-聚焦EXISTS AND IN性能分析(十六)
- Oracle-where exists()、not exists() 、in()、not in()用法以及效率差异
- Apple Pay苹果支付IOS in-App Purchase内购项目服务端校验
- AOP拦截日志报错llegalStateException: It is illegal to call this method if the current request is not in asynchronous mode
- Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
- Exception Handling in ASP.NET Web API
- Invalid command 'WSGIScriptAlias', perhaps misspelled or defined by a module not included in the ser
- [LeetCode] Average of Levels in Binary Tree 二叉树的层平均值
- [CareerCup] 10.3 Integer not Contain in the File 文件中不包含的数
- Spring – ${} is not working in @Value--转载
- Improving Lock Performance in Java--reference