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 -> Moving tables into new tablespace

Moving tables into new tablespace

From: Syltrem <syltrem_at_videotron.ca>
Date: 2000/06/27
Message-ID: <dw865.6056$LX4.120655@weber.videotron.net>#1/1 






Hi!



I want to move some tables from one tablespace to another and I don't know
what's the best way to do it.



I want to make sure my indexes and other constraints will follow.



Also, is there a way to know how much % of the space used by an index is
actually being used (equivalent to tables's dba_tables.empty_blocks)



Can someone help?



Thanx
Received on Tue Jun 27 2000 - 00:00:00 CDT












Original text of this message













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