Move index to different tablespace in oracle
How can I move index from one tablespace to another in Oracle 11g ?
ASKER
Thanks Alex. The problem is the new tablespace is with a new user. So It doesn't let me move index
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
the new tablespace is with a new userWhat does this mean??!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, I mean just the otherway.. The new user is using the new tablespace...
It is somethng like this
Olduser with OldTS(Tablespace).... Index is now in OldTS
New User with NewTS
The Index need to move from OldTS to NewTS
When the trying the Alter Tablespace , It is not letting the move of Index
It is somethng like this
Olduser with OldTS(Tablespace).... Index is now in OldTS
New User with NewTS
The Index need to move from OldTS to NewTS
When the trying the Alter Tablespace , It is not letting the move of Index
So you mean the default tablespace of the users?!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window