Home » SQL & PL/SQL » SQL & PL/SQL » move segments from one tablespace to other tablespace (oracle10g,linux)
move segments from one tablespace to other tablespace [message #346934] Wed, 10 September 2008 02:32 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I have moved index from one tablespace to other tablespace using following script:

ALTER INDEX XPKSCOTT REBUILD TABLESPACE ONLINE_LARGE_TBS;

after that i checked the XPKSCOTT index status it shows unusable state.

after moved the index from one tablesapce to other tablespace,corresponding index will unusable.

What is the reason for it?

Thanks,
Michael
Re: move segments from one tablespace to other tablespace [message #347054 is a reply to message #346934] Wed, 10 September 2008 09:27 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

wrongly, i have arised above question.

I some index unusable state when corresponding table move into one tablespace to other tablespace.

Myscripts:

alter table maple move tablespace online_small_ndx;

select index_name,status from user_indexes where status='UNUSABLE';

index_name, status
XPKMAPLE UNUSBALE

what is the reason for it.

Thanks,
Michael
Re: move segments from one tablespace to other tablespace [message #347056 is a reply to message #347054] Wed, 10 September 2008 09:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Expected behavior.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2297
Re: move segments from one tablespace to other tablespace [message #347057 is a reply to message #346934] Wed, 10 September 2008 09:44 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

>what is the reason for it.

when corresponding table move into one tablespace to other tablespace.

Previous Topic: sql question
Next Topic: Summing of record values based on certain condition
Goto Forum:
  


Current Time: Sat Dec 10 14:44:53 CST 2016

Total time taken to generate the page: 0.15768 seconds