OraFAQ Forum: Performance Tuning » 11g index can't be rebuild

Home » RDBMS Server » Performance Tuning » 11g index can't be rebuild (11g, solaris 9)

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

11g index can't be rebuild [message #447863]

Thu, 18 March 2010 04:52

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

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68649
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 01:09:50 CDT 2024