Re: Lock Table

Connor McDonald wrote:
>
> 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."
>
> ------------------------------------------------------------

The poster asked:

"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"

Renaming it is a fairly safe way of making it "not there"

-- 
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."

------------------------------------------------------------