Settings for Oracle

Oracle settings - Basic option

These settings are displayed for Oracle Enterprise or Personal editions using the 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

These settings are displayed for Oracle Enterprise or Personal editions using the 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.