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: RELOCATE TABLES FROM ONE TABLESPACE TO ANOTHER ONE ?

Re: RELOCATE TABLES FROM ONE TABLESPACE TO ANOTHER ONE ?

From: Dennis <dennis_at_bearclaws.com>
Date: Mon, 31 May 1999 09:04:19 -0500
Message-ID: <375296c1.0@news.primary.net> 





Use SQLplus COPY TABLE command.



Joël Dessart wrote in message <375142B8.89595ECA_at_expfin.be>...


>I want to know if it's possible to change a table from one tablespace


>to another one without using drop and create command.


>I have a lot of tables in a bad tablespace so if it exist an easy way to


>do so...


>Thank you,


>


>        Guillaume .


>




Received on Mon May 31 1999 - 09:04:19 CDT












Original text of this message













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