Re: 9iR2 import

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