RE: Drop Foreign Key and Insert causing deadlock
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 25 Feb 2014 20:40:54 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDFFCA_at_exmbx05.thus.corp>
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Vasu [vasudevanr_at_gmail.com] Sent: 25 February 2014 19:58
To: Mark W. Farnham
Cc: oracle-l_at_freelists.org
Subject: Re: Drop Foreign Key and Insert causing deadlock
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.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Vasu [vasudevanr_at_gmail.com] Sent: 25 February 2014 19:58
To: Mark W. Farnham
Cc: oracle-l_at_freelists.org
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 25 2014 - 21:40:54 CET