KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.
Cause: A query of an external table of type ORACLE_DATAPUMP tried to reference the ROWID column. The ORACLE_DATAPUMP access driver does not support ROWIDs.
Action: Remove the ROWID from the query. If that is not possible, create a table in the database with the same columns as the external table, copy the data from the external table into the newly created table, and use that new table for the query.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:48

KUP-04084：ORACLE_DATAPUMP访问驱动程序不支持ROWID列。,
.原因：对ORACLE_DATAPUMP类型的外部表的查询尝试引用ROWID列。ORACLE_DATAPUMP访问驱动程序不支持ROWID。,
.操作：从查询中删除ROWID。如果不可能，请在数据库中创建与外部表相同列的表，将外部表中的数据复制到新创建的表中，并将该新表用于查询。,
.

aiaiDBA

13718043309

010-86462881

KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

1 个回答

相似问题