Skip to Main Content
Forums

SQL & PL/SQL

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!

Alter column size in table which contain millions of record

nkswapnilJun 13 2016 — edited Jun 13 2016

oHi ,

I have requirement , I just need to increase size of Column of some field, but datatype of that column is CHAR. Table which I changed column size contain million tons of Record. By using Alter command I make a script and run it , but it takes lot of times to alter (Approx. say 1hrs). Is it possible way to do reduce this time .

Note : We didn't changed datatype to VARCHAR2 , just changed column size. For e.g. from CHAR(4) to CHAR(60).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2016
Added on Jun 13 2016
13 comments
6,056 views