Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max number of tables in Oracle
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 Thu Jun 10 1999 - 13:46:54 CDT