Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-30556: functional index is defined on the column to be modified

782117Feb 2 2012 — edited Feb 2 2012
Hello,
I'm altering a column length to increase the size and getting "ORA-30556: functional index is defined on the column to be modified".
On searching more about this error, it seems like the function index must be dropped before altering the column.
The table I'm dealing with is huge.

Question 1:_
In case of dropping and recreating the index, should the following steps be done:
- Drop Index
- Alter the column to increase the size
- Recreate the index with NOLOGGING and NOPARALLEL clause
- ALTER INDEX to turn on LOGGING
- Gather Statistics on that index

Question 2:_
Is there anything else that should be done when the index is dropped and re-created?

Question 3:_
What are the side-effects of carrying out the above steps in a huge table with around 15 million rows?

Question 4:_
Would it work if I disable the index, alter the column and reenable the index?


Thanks!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 1 2012
Added on Feb 2 2012
6 comments
30,545 views