ORA-40119: nested columns incompatible with missing value treatment ORACLE 报错 故障修复 远程处理
文档解释
ORA-40119: nested columns incompatible with missing value treatment
Cause: delete_row missing value treatment is not supported for nested columns.
Action: Use 2D (non-nested) data representation or manually delete the rows with NULL values and disable the delete_row missing value treatment.
ORA-40119: 嵌套列与缺失值处理不兼容
官方解释
常见案例
DELETE FROM table
WHERE column_name IS NULL;
一般处理方法及步骤
1.如果删除缺失值,那么嵌套列也就要被删除,所以应该改用其他填充技术;
2.可以使用空字符串来替换空值;
3.改为在外部嵌套查询中过滤空值;
4.使用列表函数(如case()、nvvl())将空值替换为非空值;
5.在Oracle 18c之后的版本引入了特殊处理,可以使用delete_at_null拓展新选项。