Re: Lock Table

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 8 Sep 2005 11:27:44 -0400
Message-ID: <nc2dnTtj4ZDsxb3eRVn-tQ@comcast.com>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:43204701.D31_at_yahoo.com...
> 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
>
> rename MY_TABLE to MY_TABLE_GONE
> --

not sure what you're suggesting tthis accomplishes Received on Thu Sep 08 2005 - 10:27:44 CDT