RE: Drop Foreign Key and Insert causing deadlock

From: Jonathan Lewis <>
Date: Tue, 25 Feb 2014 20:40:54 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDFFCA_at_exmbx05.thus.corp>

I wondered if you were trying to model something like that - but I didn't guess that you were playing with REF partitioning.

What EXACTLY are you trying to achieve in your archive process, and which version EXACTLY of Oracle are you using.

Jonathan Lewis

From: [] on behalf of Vasu [] Sent: 25 February 2014 19:58
To: Mark W. Farnham
Subject: Re: Drop Foreign Key and Insert causing deadlock

The archival job works on a reference partitioned table using exchange-partition method, that require the above discussed step.

Looks like a not-so-great work-around would be , doing a CTAS of child table and then dropping the partition .

Appreciate your interest.

Received on Tue Feb 25 2014 - 21:40:54 CET

Original text of this message