Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 9 Apr 2013 15:01:15 +0100
Message-ID: <CAPMSPxNcbnVWcq5bZvi9QWkHRK4JXpHq-x7bj160PRj6E=i5qQ_at_mail.gmail.com>

Hi
Another idea. Are you using deferred segment creation? So that when a value comes in that is the first for a given partition the segment gets created and is recorded as DDL?
Regards
Pete

On 9 April 2013 14:45, <Christopher.Taylor2_at_parallon.net> wrote:

> Our partitions are LIST based by an organization identifier.
>
> Chris
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Peter Hitchman
> Sent: Tuesday, April 09, 2013 5:34 AM
> To: oracle-l
> Subject: Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?
>
> Hi Chris,
> I do not think that a direct load gets reported as a DDL, I always assumed
> it is just another type of DML.
> Do you use interval partitions? Partitions getting created updates the
> last_ddl_time and so does enabling a constraint.
> Regards
> Pete
>
>

-- 
Regards

Pete


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

Received on Tue Apr 09 2013 - 16:01:15 CEST