Re: Moving index to new tablespace

From: james <james_at_fallback.com>
Date: Mon, 19 Jul 1999 15:41:37 GMT
Message-ID: <379347A9.84C60D94@fallback.com>

im currently using 8.0.5 and this works,

alter index xxxx rebuild
storage ( initial 10K next 10k pctincrease 0, etc....) tablespace xxxxx;

james N. secureportal corp.

Doug Cowles wrote:

> 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?
>
> - Dc.
Received on Mon Jul 19 1999 - 10:41:37 CDT