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

Moving index to new tablespace

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Mon, 19 Jul 1999 10:35:29 -0400
Message-ID: <379337B1.3DA163B2@bigfoot.com> 





I same from a previous posting that to move an index
from one tablespace to another, all you had to do was
alter index indexname storage (...) tablespace XXXX.
I tried this on Oracle 8.0.5 and ended up with invalid alter
command, pointing at the tablespace.  Is this an Oracle 8i thing?




Received on Mon Jul 19 1999 - 09:35:29 CDT












Original text of this message













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