RE: [Non-DoD Source] Re: Problem with disable_archive_logging

  • From: "Freeman, Donald G. CTR" <donald.freeman.ctr@xxxxxxxxxxxxxxx>
  • To: Biju Thomas <biju.thomas@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 Jul 2017 16:58:24 +0000

Hi Biju

Our goal is to combine multiple same type schemas by importing into named 
partitions.

 Here is our import command:

impdp \”/ as sysdba\”  parallel=8 dumpfile=full_expdp2_%U.dmp 
logfile=full_impdp.log  full=y table_exists_action=append content=data_only  

We need to append data since we are inserting and can't afford to replace, skip 
or truncate.  I need to research but the disable hint may cause the default 
[skip] behavior.

Donald Freeman
Systems Dev Spec, Principle
ManTech International
(757)852-6690 (w)
(717-497-1037 (C)
(757)-852-7777 PMO-IT Help Desk
RHR Facility
donald.freeman@xxxxxxxxxxx
donald.freeman.ctr@xxxxxxxxxxxxxxx





-----Original Message-----
From: Biju Thomas [mailto:biju.thomas@xxxxxxxxx] ;
Sent: Thursday, July 06, 2017 10:13 AM
To: Freeman, Donald G. CTR; oracle-l-freelists
Cc: Pope, Richard CTR; Zamperini, Hazel J. CTR
Subject: [Non-DoD Source] Re: Problem with disable_archive_logging

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 

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Other related posts: