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 tables to new tablespace

Re: Moving tables to new tablespace

From: Tanel Poder <tanel_at_@peldik.com>
Date: Wed, 11 Jun 2003 01:02:50 +0300
Message-ID: <3ee655a5$1_1@news.estpak.ee> 





> alter table <table> move tablespace <tablespace> provided you are on

> 8i or higher.




And rebuild your indexes afterwards if you have any data in your tables,
otherwise they'll remain in unusable status. (note that when moving tables
with no rows in them, Oracle is smart enough to keep index in valid status).



Tanel.
Received on Tue Jun 10 2003 - 17:02:50 CDT












Original text of this message













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