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

文档解释

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,以确保正确。

你可能感兴趣的