Hello
In fact, the column was added previuosly and my
import didn't include this new column, so without
it
the import will run correctly, during the
deadlock, i ran some request against dictionary to
verify the
lock, her drop session has put a level 5 lock(row
exclusive) and my import session has level 3 lock,
I asked
her to disconnect, no effect, I try to kill her
session, but no effect. perhaps, I must wait the
end of the drop column,
but it's a big partitionned table. It was not a
production database, she will be fired if it
was...
thank yu
"DA Morgan" <damorgan_at_psoug.org> a écrit dans le
message de news:
1157680789.145530_at_bubbleator.drizzle.com...
> Sylvestre wrote:
>> Hello
>>
>> In fact, I ask this cause one of my collegue
>> run a "drop column" order on the table where I
>> import
>> 20Gig of data, the result was a deadlock and I
>> was oblige to kill my import process...
>> so if my import session could get a table level
>> lock, it will make sense.
>>
>> Thank you
>
> DDL on a live production table? Someone should
> be taken to the woodshed.
>
> Perhaps your colleague should have been using:
> ALTER TABLE <table_name> DROP COLUMN
> <column_name> CHECKPOINT 1000;
>
> Or some other checkpoint value.
> --
> Daniel Morgan
> University of Washington
> Puget Sound Oracle Users Group
Received on Fri Sep 08 2006 - 00:42:54 CDT
