Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving index to new tablespace
Oh, I forgot REBUILD.
Thanks. Not enough coffee this morning.
james wrote:
> 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 - 14:15:29 CDT