Home » RDBMS Server » Server Administration » Does the Index which was moved to the other tablespace would be rebuilt concurrency?
Does the Index which was moved to the other tablespace would be rebuilt concurrency? [message #301830] Thu, 21 February 2008 23:00 Go to next message
trantuananh24hg
Messages: 668
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!
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 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use the ONLINE keyword but nevertheless there is an exclusive lock during a small amount of time.

Regards
Michel
Previous Topic: Bug No. 6376915
Next Topic: Restrict the system connecting to the database
Goto Forum:
  


Current Time: Fri Dec 02 20:30:20 CST 2016

Total time taken to generate the page: 0.20770 seconds