Re: How to know whether the table was locked or not?
Posted by: Kasthuri Gandhi
Date: June 29, 2010 02:57AM

Its working.. But I am unable to insert or update the records in any other tables. How to lock only particular tables without affecting others.

Eg.

I locked a table 'company' using lock table query and then I tried to retrive the records from some other table. I got error as

ERROR 1100 (HY000): Table 'branch' was not locked with LOCK TABLES

So I need to know how to lock particular table and the other tables should not be affected by this.

-- Kasthuri Gandhi



Edited 1 time(s). Last edit at 06/29/2010 03:17AM by Kasthuri Gandhi.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to know whether the table was locked or not?
3956
June 29, 2010 02:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.