Hi, Please help me with the best way to change the datatype of a column in a all tables in DB from bigint to varchar. Please consider the following facts.
- DB Size - 75 TB - Number of tables - ~100 - Some tables are partitioned and some are not partitioned. - All partitioned tables are big in size. - For reference, the largest partition size is 4 TB, similarly the size of 10-12 partitions ranges between 1 to 4 TB. - We have indexes and FK on tables. - Physical Replication is configured with 2 standby DBs. -- Thanks & Regards Gambhir Singh
