OraFAQ Forum: Server Administration » Moving an INDEX to a different TABLESPACE

Home » RDBMS Server » Server Administration » Moving an INDEX to a different TABLESPACE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving an INDEX to a different TABLESPACE [message #59109]

Tue, 28 October 2003 12:09

Mark K
Messages: 18
Registered: October 2003

Junior Member

Hello all,

I have found the command to move a table from one tablespace to the other:

alter table mktest1
move tablespace <newtblspace>

I can't find an equivalent for an INDEX. How can I move an index to a new tablespace?

Thanks.

-- Mark.

Report message to a moderator

Re: Moving an INDEX to a different TABLESPACE [message #59111 is a reply to message #59109]

Tue, 28 October 2003 12:41

Thiru
Messages: 1089
Registered: May 2002

Senior Member

alter index 'index_name' rebuild tablespace 'new_tspace';

Report message to a moderator

Re: Moving an INDEX to a different TABLESPACE [message #59112 is a reply to message #59111]

Tue, 28 October 2003 12:45

Mark K
Messages: 18
Registered: October 2003

Junior Member

Thanks!

I was just coming back to post what I had found -- which is what you suggest -- and you had already posted.

So thanks again, and have a smooth day.

-- Mark.

Report message to a moderator

Previous Topic:	A question about checkpoint and log switch
Next Topic:	Oracle Server Architecture

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 21 10:45:36 CST 2025