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: 64152
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
Previous Topic: SYSTEM TABLESPACE RESIZE
Next Topic: resize datafile
Goto Forum:
  


Current Time: Sun Dec 11 00:04:36 CST 2016

Total time taken to generate the page: 0.11184 seconds