RE: Drop Foreign Key and Insert causing deadlock
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Feb 2014 20:40:54 +0000
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
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Vasu [vasudevanr@xxxxxxxxx]
Sent: 25 February 2014 19:58
To: Mark W. Farnham
Cc: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
