Re: Problem with disable_archive_logging

  • From: Biju Thomas <biju.thomas@xxxxxxxxx>
  • To: donald.freeman.ctr@xxxxxxxxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 06 Jul 2017 14:12:31 +0000

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@xxxxxxxxxxxxxxx> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2017