11g index can't be rebuild [message #447863] |
Thu, 18 March 2010 04:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
orafacjublu wrote on Thu, 18 March 2010 05:10online 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
|
|
|