ANy thought for Locking issue on the following code
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 21 Feb 2005 08:42:01 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » ANy thought for Locking issue on the following code
