OraFAQ Forum: Server Administration » Does the Index which was moved to the other tablespace would be rebuilt concurrency?

Home » RDBMS Server » Server Administration » Does the Index which was moved to the other tablespace would be rebuilt concurrency?

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

Does the Index which was moved to the other tablespace would be rebuilt concurrency? [message #301830]

Thu, 21 February 2008 23:00

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Hi all!

For the accident, I found that many indexes was created with tablespace SYSTEM, and then, I have got a decision to move them to the other tablespace, USERS.

However, I wonder about them will be rebuilt concurrency when I use the command

SQL> alter index CSN.PS_102007 rebuild tablespace USERS;

Because of more generation redo log file when if index is rebuilt, then I feel to bother.

Thank you for your reply!

Report message to a moderator

Re: Does the Index which was moved to the other tablespace would be rebuilt concurrency? [message #301852 is a reply to message #301830]

Fri, 22 February 2008 00:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use the ONLINE keyword but nevertheless there is an exclusive lock during a small amount of time.

Regards
Michel

Report message to a moderator

Previous Topic:	Bug No. 6376915
Next Topic:	Restrict the system connecting to the database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 23:36:52 CST 2024