Re: Default/Temp tablespaces

From: n <n_at_m.com>
Date: 2000/07/16
Message-ID: <#uDvwv67$GA.281@cpmsnbbsa07>#1/1

in addition to changing their default and temp tablespaces, which will only take care of objects created in future, you might also want to move them out of system tablespace or you could get into trouble soon.

drey.

Sid_James <sid.james_at_virgin.net> wrote in message news:3972287F.1CFF_at_virgin.net...
> Hi.
>
> About a 100 of our users have been given SYSTEM as their default user
> and temporary tablespaces! Is their an automated way that can change
> these to the USER and TEMP tablespaces instead?
>
> Thanks.
>
> Ed.
Received on Sun Jul 16 2000 - 00:00:00 CDT