Good afternoon all, I have a database 11gR2 on solaris 10, we have a partitioned table with over 60millions of rows, and data from 2012 till now.
We have been asked to change the data type of one column from number to varchar. What is the best approach to accomplish this.
Also we need to change the column of the the partition