Skip to Main Content
Forums

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!

Byte vs. char semantics and indexes

524657Jul 1 2010 — edited Jul 1 2010
I am changing a field in a rather large table (500 mill+ rows) from byte semantics to char semantics by simply issuing
ALTER TABLE CTB.CTB_CORE_ACT_CD_SETS MODIFY
(CONCEPT_CODE VARCHAR2(50 CHAR)) -- takes very litle time

The problem is that concept_code is also part of an index.
Now the question is : is it really necessary to rebuild this enourmous index?
In test (same size) it took about 10 hours by dropping and recreating.

I will be investigaing the possibility of doing a 'rebuild online' , but maybe it isn't even necessary ?

Regards
Kurt Laugesen
This post has been answered by mbobak on Jul 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2010
Added on Jul 1 2010
#dba, #general-database-discussions, #performance, #table
5 comments
1,139 views