user8895369 wrote:do NOT use CHAR; use VARCHAR2
Below are our working environment details.
Oracle version: 220.127.116.11.0
OS version : AIX 6.1
We have a table emp_details with 23772889 records. Our requirement is to increase few of the columns size in the table emp_details. We are following the below alter statement which is taking around 2 hours of time.
ALTER TABLE emp_details
Is there any way to improve the above query performance? Greatly appreciated if anyone has any ideas on how to speed this up. Thank you.
user8895369 wrote:It would be better to change the code.
Thank you all for your valuable suggestions. I have a functional dependency So it is mandatory for me to use char datatype itself. I mean, there should be empty spaces to be added at the end as code is looking for the empty space as well. Can we have any other possibility even if we choose char datatype?
user8895369 wrote:One suggestion:-
2. Update the original column's data (for which you want to change the data type) into temporary column using BULK UPDATE logic.