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

From: <Christopher.Taylor2_at_parallon.net>
Date: Tue, 9 Apr 2013 08:45:44 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E8879BCB35D1_at_NADCWPMSGCMS10.hca.corpad.net>

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 09 2013 - 15:45:44 CEST

This message: [ Message body ]
Next message: Peter Hitchman: "Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?"
Previous message: Taral Desai: "Re: What does it mean when CREATE INDEX"
In reply to: Peter Hitchman: "Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?"
Next in thread: Peter Hitchman: "Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?"
Reply: Peter Hitchman: "Re: Question: MERGE or INSERT /*+ APPEND */ causes INDEX DDL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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

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