ANy thought for Locking issue on the following code

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Mon, 21 Feb 2005 08:42:01 -0800 (PST)
Message-ID: <20050221164202.81962.qmail@web51301.mail.yahoo.com>

Dear friend

We have deployed a production change today. Change incloves a Pro*C program running at backed from Application server and doing some insert into the table 1,2,3 based on certain condition. This is now taking an exclusive index on the Table1 Primary Key Partitioned index. Table1 is partition Locally and new partition are created daily. Due to lock, I am not able to add partition. Can somebody point as what need to be checked.

Table1 is having One primary Key and one Foreign Key. Table1 is partitioned Locally. It has exclusive lock on table1 Primary Key index partiton and Row exclusinve for table partition.

Any comment
TIA
sanjay

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Mon Feb 21 2005 - 11:48:39 CST