ORA-39179: unable to load table “string”.”string” because of OID transform ORACLE 报错 故障修复 远程处理

文档解释

ORA-39179: unable to load table “string”.”string” because of OID transform

Cause: The OID transform for the job was set to false and the identified table contained either VARRAYs with non-final types or unscoped REF columns. Both of these column types have embedded OIDs so they

Action: You must manually move the data with the specified tables when OIDs are not preserved.

ORA-39179: 无法载入表”string”.”string”，因为有OID转换。

官方解释

常见案例

一般处理方法及步骤

1.确认目标表的OID项的格式是否正确，如果没有，请添加OID列。

2.重建错误表格，这样可以确保表格的OID正确。

3.确认客户端应用程序和数据库的版本完全一致。

4.使用SQL加载更新OID，以确保正确。