Hi, Its version 19C oracle exadata, We have a requirement to alter a nullable column which is currently number(14) and should be modified to varchar2(20). The table holds ~500 million rows and ~65GB in size. When trying to directly ALTER its giving below error message. But considering the large table what will be the fastest way with minimal downtime? Or anyway can be done without any application impact?
ORA-01439: column to be modified must be empty to change datatype