Re: getting data out of system tablespace

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 08 Sep 1999 19:15:41 GMT
Message-ID: <37d9b29a.7279234@news.siol.net>

On Wed, 8 Sep 1999 08:17:02 -0600, "Larry Pettit" <larry.pettit_at_ps.net> wrote:

>I received an import file from another system that I needed to load. I
>created another user id, assigned that user id to it's own tablespace
> user_data) and even did the import load under that user id, but it still
>put it into the system tablespace. How can I move it into another
>tablespace?

Before performing import, revoke any quota on SYSTEM tablespace from your <new_user>, eg:

ALTER USER <new_user> QUOTA 0 ON SYSTEM;

That way the tables that originated in the SYSTEM tablespace will be created in the user's default tablespace (if hi has sufficient quota there).

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Sep 08 1999 - 14:15:41 CDT