ORA-39815: Direct Path Unload of an external table is not allowed. ORACLE 报错 故障修复 远程处理

文档解释

ORA-39815: Direct Path Unload of an external table is not allowed.

Cause: An attempt was made to use Direct Path API Unload to unload an external table.

Action: Do not use Direct Path Unload to unload an external table.

？

ORA-39815: Direct Path Unload of an external table is not allowed.

官方解释

常见案例

一般处理方法及步骤

1. 创建导出表：

CREATE TABLE export_table AS

SELECT * FROM external_table;

2. 执行ALTER TABLE EXPORT：

ALTER TABLE export_table EXPORT TO ‘/.csv’ FORMAT CSV;

3. 删除导出表：

DROP TABLE export_table;