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