Home -> Mailing Lists -> Oracle-L -> Re: Problem with disable_archive_logging

Re: Problem with disable_archive_logging

From: Biju Thomas <biju.thomas_at_gmail.com>
Date: Thu, 06 Jul 2017 14:12:31 +0000
Message-ID: <CAF9tyKoNUjiBG2jfpNNVDYhP5qJVMpsTF6=WvPvWxLdoyrXLpQ_at_mail.gmail.com> 








Not sure if the INSERT behavior changes with DISABLE_ARCHIVE_LOGGING
parameter or not. By default,12c impdp uses APPEND hint with the INSERT
statement. Try with "DATA_OPTIONS = DISABLE_APPEND_HINT".



-Biju



On Thu, Jul 6, 2017 at 7:19 AM Freeman, Donald G. CTR <
donald.freeman.ctr_at_ablcda.navy.mil> wrote:



> While loading data via Impdp, and using the option

> "disable_archive_logging"

> set to 'Y", It appears that oracle isn't reusing empty blocks when

> performing Impdp.  Could this be a potential bug in 12C, or are we missing

> something?

>

>

> Donald Freeman

> Systems Dev Spec, Principle

> ManTech International

>

>

>

> --



Best,


Biju Thomas


www.bijoos.com


--
http://www.freelists.org/webpage/oracle-l


Received on Thu Jul 06 2017 - 16:12:31 CEST












Original text of this message