I am trying to perform Oracle Data pump Export (using API) over a network link on a server running linux.
When I run the API I get the following error:
ORA-31693: Table data object TABLE NAME failed to load/unload and is being skipped
due to error: ORA-30657: operation not supported on external organized table.
The export works fine with expdp command, plus the tables are not external.
I am using DATA PUMP API as follows
jobNo:= DBMS_DATAPUMP.OPEN ('EXPORT','SCHEMA',NetworkLINK,'EXPORT_JOB123','LATEST');
DBMS_DATAPUMP.ADD_FILE(
handle => jobNo,
filename => DumpFilename,
directory =>Directory name );
The procedure seems to run fine, when I use the SYSTEM schema. But still the errors persist from other schemas.