Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |