Alter Index Rebuild Tablespace

[scohan]

I'm trying to run some alter index statements to move the indexes into an index tablespace. For example:

alter index ERROR_ID rebuild tablespace indx;

This worked in my DB that used dictionary managed tablspaces, but doesn't work in another DB using locally managed tablespaces. For the latter, I get a 'index created' message it's tablespace name in user_indexes still says the old tablespace.

Will this not work for locally managed tablespaces?
If not, how can I move the indexes to the indx tablespace?

Is there a way to specify that all indexes default to the indx tablespace when they are created?

Thanks.

 

[flstffatboy]

Schoan,

I believe you need to first convert the tablepsace from locally managed to dictionary managed run the alter index command then convert the tablespace back to locally managed.

FLSTF

 

[carp]

In which case, wouldn't it be easier to drop the index and recreate it?