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

Please let me know if TABLE_EXISTS_ACTION=APPEND behavior changes with DATA_OPTIONS=DISABLE_APPEND_HINT.
I do not think there is any impact.

-Biju

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

> 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 <(757)%20852-6690> (w)
> (717-497-1037 <(717)%20497-1037> (C)
> (757)-852-7777 <(757)%20852-7777> PMO-IT Help Desk
> RHR Facility
> donald.freeman_at_mantech.com
> donald.freeman.ctr_at_ablcda.navy.mil
>
>
>
>
>
> -----Original Message-----
> From: Biju Thomas [mailto:biju.thomas_at_gmail.com]
> 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_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
>

-- 
Best,
Biju Thomas
www.bijoos.com

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