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
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------
Received on Thu Sep 08 2005 - 09:13:21 CDT
