locking the whole table does not make sense - you are removing one of the
more important design features of Oracle!
Nicolas Bronke wrote in message <375ffa16_at_news.uk.ibm.net>...
>If you want a table lock use the command lock table xxx exclusive (or else
>refer to the user manual)
>Regards
>Nicolas
>
>Bill Mann <bill.mann_at_worldtalk.com> schrieb in im Newsbeitrag:
>375FE55E.DCB30D46_at_worldtalk.com...
>> I used to think that Oracle did locking at the table level, but I been
>> corrected that locking is performed at the record level - hence I
>> probably need to change my design. Either way, I was planning to have
>> one table per customer in my database. Is there any limitations to the
>> number of tables allowed in Oracle. What are the issues that I should
>> be aware of.
>> Thanks,
>> Bill.
>>
>
>
Received on Fri Jun 11 1999 - 14:35:45 CDT
