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;