Moving Indexes [message #327624] |
Tue, 17 June 2008 01:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
saharookiedba
Messages: 56 Registered: September 2007 Location: PUNE
|
Member |
|
|
Hi,
I have done a Import of a user from database to a newly ceated user, In this case all the tables and indexes of that user have gone to a default tablespace that was mentioned during the user creation.
I want to move all the indexes to another tablespace.
How should i go about it.
Please let me know..
Thank you.
|
|
|
Re: Moving Indexes [message #327632 is a reply to message #327624] |
Tue, 17 June 2008 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | In this case all the tables and indexes of that user have gone to a default tablespace that was mentioned during the user creation.
|
Only if original tablespace does not exist or user has no quota on it.
ALTER INDEX REBUILD, see SQL Reference.
Regards
Michel
|
|
|