Search code examples
oracleexternaldatapump

Exporting data via External Table - Parallel Not Working

We are running Oracle 12c SE, (12.2.0.1.0). We are trying to unload a very large table via this command:

CREATE TABLE customer_ext
 ORGANIZATION EXTERNAL (
 TYPE ORACLE_DATAPUMP
 DEFAULT DIRECTORY temp_directory
 LOCATION ('customer1.dmp','customer2.dmp')
 )
 PARALLEL 2
AS  SELECT * FROM customer;

Per Oracle documentation, if the PARALLEL clause is used, and you specify multiple files, then multiple files will be created. However, in the example above, even though the customer table has more than 7 million records, only 1 file is created.

Is there anything version related, or that this is SE and not EE, or something else that would cause this option not to be used?

Thanks!!

Solution

  • Per the docs: Oracle Database Editions, parallelism is only available in EE. If you request parallelism in your DDL but it's not available for any reason, your process will remain serialized, in which case it will only use the first of your file locations and ignore any others (per ORACLE_DATAPUMP Access Driver).