Provides notes for using Oracle Data Pump import on Autonomous Database.

By default the Oracle Data Pump Import utility imports data with the same compression type as specified for tables on the source database (the database where you exported your data from). If you want to leave compression to Autonomous Database, specify the following parameter when you import your data:

TRANSFORM=TABLE_COMPRESSION_CLAUSE:NONE

The TRANSFORM parameter with this option specifies that Oracle Data Pump Import should ignore the compression type of your source tables. Using this option, Oracle Data Pump imports the tables into Autonomous Database using the default compression type, where the default compression type depends on the Autonomous Database workload type:

• Data Warehouse: The default table compression is Hybrid Columnar Compression.

  Oracle recommends using this default if your application primarily uses bulk load operations on your tables, as the loads will compress the data. Query performance on these tables will benefit from compression as queries need to do less IO.

  If you have staging tables replicated from other systems using Oracle GoldenGate or other replication tools, or your application primarily uses row-by-row DML operations on tables, Oracle recommends keeping the tables uncompressed or using Advanced Row Compression.

• Transaction Processing: The default table compression is no compression.

• JSON Database: The default table compression is no compression.

• APEX: The default table compression is no compression.

See TRANSFORM for more information on the Oracle Data Pump Import TRANSFORM parameter.

See About Table Compression for more information.