Re: can you take a schema offline?
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Thu, 12 Mar 2009 17:04:56 -0500
Message-ID: <sEful.9476$%54.3461_at_nlpi070.nbdc.sbc.com>
rgvguplb wrote:
> 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
Date: Thu, 12 Mar 2009 17:04:56 -0500
Message-ID: <sEful.9476$%54.3461_at_nlpi070.nbdc.sbc.com>
rgvguplb wrote:
> 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
Having problems learning to be a DBA??
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/auditing.htm Received on Thu Mar 12 2009 - 17:04:56 CDT