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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to move a user's tables from one tablespace to another tablespace.

Re: How to move a user's tables from one tablespace to another tablespace.

From: Steve Phelan <stevep_at_no-spam.pmcgettigan.demon.co.uk>
Date: 1997/07/08
Message-ID: <33C1ED2C.18EB2BD4@no-spam.pmcgettigan.demon.co.uk>#1/1 







Poon Chak Yau wrote:



> Hello,

>         I want to move a user's tables from SYSTEM table space to

> another table space. Can anyone tell me how to do it  without

> affecting operations?

>

> Regards,






Use the Oracle Export and Import utilities (at 'user' level). Oh, and
don't forget to alter the users default tablespace from SYSTEM before
you import.



Steve Phelan.
Received on Tue Jul 08 1997 - 00:00:00 CDT












Original text of this message













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