Re[1]:TM lock problem

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 9 Sep 2004 14:16:11 -0000
Message-ID: <20040909141611.20122.qmail@webmail6.rediffmail.com>

Hi all,
actually what the developer did was :

---

As TEST user (SQLPLUS session 1):   

  DELETED 40,000 rows from ERR table
(did not COMMIT)

As TEST user (SQLPLUS session 2):   

(before DELETE is completed)

  SELECT COUNT(*) FROM ERR ;

---

This SELECT did not return back
immediately . This is what her problem was. She has come to know that the table has been locked and assumed that it's a problem.

Me not communicating with her properly
and my lack of knowledge about LOCKS
has led to this confusion .

my SINCERE APOLOGIES to the LIST.
I will have read the concepts guide.

Anyway thanks Ganesh ,Steve,Powell,sol beach , Manjula and Diego Cutrone . Sorry to waste ur time.I will take care that this will not happen again .

Regards,
Prem.

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Received on Thu Sep 09 2004 - 09:13:04 CDT