Home » RDBMS Server » Performance Tuning » 11g index can't be rebuild (11g, solaris 9)
11g index can't be rebuild [message #447863] Thu, 18 March 2010 04:52 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Dear all,
Can anybody give a solution why alter index ** rebuild is working fine in my 9i but giving error ora-00054 in 11g

Report message to a moderator

Re: 11g index can't be rebuild [message #447873 is a reply to message #447863] Thu, 18 March 2010 05:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
ORA-00054: resource busy and acquire with NOWAIT specified
 *Cause:  Resource interested is busy.
 *Action: Retry if necessary.

It has nothing with version but with concurrent access.
Use ONLINE option, possibly.

Regards
Michel

Report message to a moderator

Re: 11g index can't be rebuild [message #447875 is a reply to message #447873] Thu, 18 March 2010 05:10 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
online option is used

Report message to a moderator

Re: 11g index can't be rebuild [message #447880 is a reply to message #447875] Thu, 18 March 2010 05:25 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
orafacjublu wrote on Thu, 18 March 2010 05:10
online option is used

I do not trust you.

Use SQL*Plus and copy and paste your session.

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel

Report message to a moderator

Previous Topic: Lot of Trace files under udump,bdump with error: Ioctl ASYNC_CONFIG error, errno = 1
Next Topic: Slow connection in Linux 64 bit oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 08:23:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.