can you take a schema offline?

From: rgvguplb <rgvguplb_at_gmail.com>
Date: Thu, 12 Mar 2009 13:25:49 -0700 (PDT)
Message-ID: <40c0413c-db79-433a-bf1d-aa507fec3f3a_at_g38g2000yqd.googlegroups.com>

i have a couple of schemas i suspect are not used any longer but am not sure.
is there a way i can make them inaccessible before actually dropping them?

or do i basically have no option other than drop them?

I thought i might be able to take the tablespace where its objects are in offline, but another schema shares that tablespace, so taking that offline does not seem to be an option.

I am using 10gR2 on windows server 2003.

thanks Received on Thu Mar 12 2009 - 15:25:49 CDT