Basic Compression Is Not Applied When Inserting Into Remote Table (Doc ID 1390050.1)

Last updated on APRIL 28, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

insert /*+APPEND*/ into remote_table select from local table does not compress data inserted into the table.

An example for such a statement is the following:

INSERT /*+APPEND */ INTO mytable@mydblink (SELECT * FROM othertable);

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms