Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a table from one Tablespace to another

Re: Moving a table from one Tablespace to another

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 8 Jan 2000 22:47:15 +0100
Message-ID: <947368128.7821.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US