Re: Import Data and store them in a # tablespace

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 23 Apr 2004 12:55:10 +0200
Message-ID: <c6asme$5fd$1@nntp.fujitsu-siemens.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> schrieb im Newsbeitrag news:pc8h80phf0mr5ib3q2nmne9i0o4gidb2nq_at_4ax.com...
> On Thu, 22 Apr 2004 19:02:37 +0200, "Volker Hetzer"
> <volker.hetzer_at_ieee.org> wrote:
>
> >Sorry for this idiotic way but AFAIK that's the oracle recommended way.
>
> It's not.
> Just make sure the user doesn't have UNLIMITED TABLESPACE privilege,
> has QUOTA on the target tablespace, 0 QUOTA on the original tablespace
> and change his DEFAULT TABLESPACE.
>
> That's all there is to it.

Does this work with LOBs too?

Greetings!
Volker Received on Fri Apr 23 2004 - 05:55:10 CDT