Re: Importing into another tablespace

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 07 Sep 1999 20:16:57 GMT
Message-ID: <37d56ef3.1548365@news.siol.net>

On Tue, 7 Sep 1999 21:48:45 +0200, "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote:

>Hi Dirk,
>
>- Make sure the destination tablespace is the default tablespace of the user
>- Make sure the user doesn't have resource or unlimited tablespace privilege
>- alter user <username> quota unlimited on <destination tablespace>

This could still result in imported tables ending in the original tablespace!

The main point is omitted above: you should revoke any quota (ie set it to 0) *on the original tablespace* for the importing user. This way, the tables will be created in the user's default tablespace.

>Hth,
>Sybrand Bakker, Oracle DBA

Regards,
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 Tue Sep 07 1999 - 15:16:57 CDT