Re: wierd locking issue
Date: Tue, 26 Feb 2008 12:32:12 +0100
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?
kfReceived on Tue Feb 26 2008 - 05:32:12 CST