Re: moving one user schema out of system tablespace

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 9 Mar 2003 21:05:06 +0200
Message-ID: <3e6b8fb0_2@news.estpak.ee>

Hi!

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:v6mr758om5sf5d_at_corp.supernews.com...
> Watch your tablespace quotas or the import will put things back where they
> were.

If talking about default users, you also should verify that they do not have UNLIMITED TABLESPACE privilege (which is in often granted role RESOURCE), otherwise the quotas have no effect..

(This resource role granted too easily granted to regular users is actually the main reason why we get (big) user segments in system tablespace and therefore have all kinds of problems such as system tabespace full, etc..)

Tanel. Received on Sun Mar 09 2003 - 13:05:06 CST