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

  • From: <Christopher.Taylor2@xxxxxxxxxxxx>
  • To: <pjhoraclel@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 9 Apr 2013 08:45:44 -0500

Our partitions are LIST based by an organization identifier.

Chris

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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

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


Other related posts: