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: Moving tables from one tablespace to another

Re: Moving tables from one tablespace to another

From: Wit Serdakovskij <wit_no_at_spam_dba.kiev.ua>
Date: 14 Jul 2004 16:49:34 GMT
Message-ID: <20040714164934.GX5337@tormoz.net> 





Hello, John,



near 15:50 14-Jul from john_at_horve.net:



> Hello,

> 

> Is it possible to move tables from one tablespace to another tablespace?




Positive.



> If so, does anyone have the SQL for this operation ?




alter table t1 move tablespace INDX;


-- 
wbr,
Wit.

P.S. RTFM at otn.oracle.com


Received on Wed Jul 14 2004 - 11:49:34 CDT












Original text of this message













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