The cleanest way to do this would be to create a new table with varchar datatype for the partition key along with the partitions and then move the data partition-by-partition.
The rollback would be super easy as well in case some issues arise in applications due to change of datatype.
Regards,
Akshay
On Mon, Jun 16, 2025 at 6:47 PM Gambhir Singh <gambhir.singh05@xxxxxxxxx> wrote:
Please help me on thisThanks & Regards
Gambhir SinghOn Mon, 16 Jun 2025 at 12:45, Gambhir Singh <gambhir.singh05@xxxxxxxxx> wrote:Hi,We have a partition table with partitioning type range and got the requirement from the application team to alter the datatype of partitioning key from bigint to varchar. Please suggest to me the way how this can be achieved.Data volume is quite huge in the table. ~50 Billion rows--Thanks & Regards
Gambhir Singh
