Home » RDBMS Server » Server Administration » Moving Indexes
Moving Indexes [message #327624] Tue, 17 June 2008 01:32 Go to next message
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
Michel Cadot
Messages: 68718
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
Previous Topic: SYSTEM TABLESPACE RESIZE
Next Topic: resize datafile
Goto Forum:
  


Current Time: Tue Dec 03 21:39:41 CST 2024