DataPump Network_Link Import Ignores DISABLE_APPEND_HINT

(Doc ID 2273873.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When use DATA_OPTIONS=DISABLE_APPEND_HINT with NETWORK_LINK in DataPump import, DISABLE_APPEND_HINT doesn't take effect.
The issue can be reproduced by running below testcase in 12.1.0.2:

Site A:
========
SQL> create user test identified by test;
User created.

SQL> grant dba to test;
Grant succeeded.

SQL> conn test/test
Connected.
SQL> create database link dl_r12102 connect to test identified by test using 'siteb_r12102';

Database link created.

Site B:
========
SQL> create user test identified by test;
User created.

SQL> grant dba to test;
Grant succeeded.

SQL> conn test/test
Connected.

SQL> create table t1(a number, b varchar2(30));
Table created.

SQL> insert into t1 values (1,'a');
1 row created.

SQL> commit;
Commit complete.

Site A:
========
$ impdp test/test network_link=dl_r12102 logfile=t1.imp.log tables=(t1) data_options=disable_append_hint trace=480301


The trace file shows below SQL:

===> Although DISABLE_APPEND_HINT is set, Oracle still uses append hint.

Changes

This is a new installed database and you are using impdp to import data via a database link.

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