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!

Change datatype on column on large table quickly

user5716448Apr 25 2014 — edited Apr 25 2014

Hi,

We have a table approx 500 million rows and added column to it (empty).

Tried dropping column but very slow, changing datatype also very slow (taking over 10 mins so killed).

Test system - how can we either drop it or change column type quickly.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2014

Added on Apr 25 2014

#general-database-discussions

6 comments

800 views