Re: Lock Table

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 08 Sep 2005 09:04:47 -0700
Message-ID: <1126195440.837230@yasure>

Iain William Wiseman wrote:
> sybrandb_at_yahoo.com wrote:
>

>>If you require Oracle to behave like Sqlserver, you would better switch
>>to Sqlserver.
>>In Oracle it simply isn't possible to fully lock out readers.
>>

>
>
> So how can I test the unavailability of a table in an application? We
> want to make sure the whole thing does not go belly up when table is not
> there
>
> Thanks,
> Iain
> New Zealand
>
> PS. I would be more with the DB2 brigade rather than MS

Query the data dictionary.

But if you need to test whether a table is there you have a massive security problem and you'd best address that instead.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Sep 08 2005 - 11:04:47 CDT