Re: Moving a table from one Tablespace to another

You need to make sure
- the user doesn't have the unlimited tablespace privilege   (revoke unlimited tablespace from ...) - the user has no quota on the old tablespace   (alter user ... quota 0 on <tablespace_name) - he does have quota on the new tablespace

Hth,

--
Sybrand Bakker, Oracle DBA
Carl-G. Johansson <c_joh_at_hotmail.com_NOSPAM> wrote in message news:jtLd4.81$mr.186819072_at_newsa.telia.net...
> Hello!
>
> I wonder if someone can give me a hint on how to move a table from one
> tablespace to another.
>
> I have exported the table to a dump file and thought I could just change
the
> table owners default tablespace, taking the original tablespace for the
> table off line, but that didn't help.
>
> As I understand it an import allways want's to put the table in the
> tablespace from where it was exported.
>
> Any ideas about this?
>
> --
> Regards
> Carl Johansson
>
>
Received on Sat Jan 08 2000 - 15:47:15 CST