Options for Oracle

Oracle settings - Basic option

Use compression. If selected, creates tables for export with compression.

Compression for. Choose the level of compression.

  • Default. Enables default compression (for example, CREATE TABLE MYTABLE(…) COMPRESS; in SQL). In this case, it has the same effect as the Basic option.
  • Basic. Enables basic compression (for example, CREATE TABLE MYTABLE(…) COMPRESS BASIC; in SQL).

Oracle settings - Advanced option

Use compression. If selected, creates tables for export with compression.

Compression for. Choose the level of compression.

  • Default. Enables default compression (for example, CREATE TABLE MYTABLE(…) COMPRESS; in SQL). In this case, it has the same effect as the Basic option.
  • Basic. Enables basic compression (for example, CREATE TABLE MYTABLE(…) COMPRESS BASIC; in SQL).
  • OLTP. Enables OLTP compression (for example, CREATE TABLE MYTABLE(…)COMPRESS FOR OLTP; in SQL).
  • Query Low/High. (Exadata servers only) Enables hybrid columnar compression for query (for example, CREATE TABLE MYTABLE(…)COMPRESS FOR QUERY LOW; or CREATE TABLE MYTABLE(…)COMPRESS FOR QUERY HIGH; in SQL). Compression for query is useful in data warehousing environments; HIGH provides a higher compression ratio than LOW.
  • Archive Low/High. (Exadata servers only) Enables hybrid columnar compression for archive (for example, CREATE TABLE MYTABLE(…)COMPRESS FOR ARCHIVE LOW; or CREATE TABLE MYTABLE(…)COMPRESS FOR ARCHIVE HIGH; in SQL). Compression for archive is useful for compressing data that will be stored for long periods of time; HIGH provides a higher compression ratio than LOW.