OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Move Index

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

Move Index [message #64392]

Fri, 21 January 2005 01:49

AL
Messages: 24
Registered: October 2000

Junior Member

Hello,

I am working with oracle 9.2.0.4 in a Redhat-enviroment.
My problem:
I have a lot of indezes in the user-tablespaces. So I want to move it to the index-tablespace.
For this I want to use "alter index myindex rebuild tablespace newtablespace".
Questions:
Is it possible to make this while the db is running? Or have my users to disconnect?
And does this command rebuild the indezes 1 to 1 or is it necessary to clearify any parameters?

Report message to a moderator

Re: Move Index [message #64393 is a reply to message #64392]

Fri, 21 January 2005 03:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You the REBUILD ONLINE option.
it can be done online.

mag@mutation_mutation > create index myIndex on emp (ename) tablespace users;

Index created.

mag@mutation_mutation > select index_name,table_name, tablespace_name from user_indexes where index_name='MYINDEX';

INDEX_NAME                     TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
MYINDEX                        EMP                            USERS

mag@mutation_mutation >  alter index myindex rebuild online  tablespace tools;

Index altered.

mag@mutation_mutation > select index_name,table_name, tablespace_name from user_indexes where index_name='MYINDEX';

INDEX_NAME                     TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
MYINDEX                        EMP                            TOOLS

Report message to a moderator

Re: Move Index [message #64407 is a reply to message #64393]

Mon, 24 January 2005 00:37

AL
Messages: 24
Registered: October 2000

Junior Member

Thank you!

Report message to a moderator

Previous Topic:	loss of controlfile
Next Topic:	How to check Migrated/Chained rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 04:06:28 CST 2025