Re: Moving system user owned objects

From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 09 Nov 2001 01:08:25 GMT
Message-ID: <Xns9153AE5BE3AA0SunnySD@24.0.3.73>

"Leigh Gold" <intan_5ee_at_yahoo.com> wrote in news:9seb4c$u9d$1_at_news3.cadvision.com:

> Hi,
>
> I took over a database which has the system user's default tablespace
> to be the same as other users. I would like to separate the system
> user's object to a tablespace by itself, can I do that?
>
> The objects owned are with names like AQ$, SYS_,DEF$
>
> Thanks,
>
> Leigh
>
>
>

YES! Move the users into a tablespace other than SYSTEM. Received on Thu Nov 08 2001 - 19:08:25 CST