| Moving Indexes [message #327624] |
Tue, 17 June 2008 01:32  |
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  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
