Re: wierd locking issue

you may issue a

LOCK TABLE your_table IN EXCLUSIV MODE;

just before the ALTER TABLE ... ADD/SPLIT/DROP PARTITION ...

in your code to force a wait.

> I have code that adds and drops partitions. I am constantly getting this error. I am doing a few things to track this down and alleviate it.
>
> 1. at the beginning of the execution of my package I issue:
> alter session set ddl_wait_for_locks=true;
>
> now I thought that with this set to true, I would just wait when adding or dropping a partition instead of erroring out?
>

regards

kf

--
http://www.freelists.org/webpage/oracle-l