Modifying column faster way
From: yudhi s <learnerdatabase99_at_gmail.com>
Date: Fri, 26 May 2023 01:21:25 +0530
Message-ID: <CAEzWdqfizFkCWHz4p1pbivepkNMRM2XJxwcL0Ckxa7o84nVVLQ_at_mail.gmail.com>
Hello Listers, We have a big table ~3.5TB in size holding ~15billion+ rows , 65 columns and its range partitioned(~200+ partition) on a date column and hash subpartition(32 hash subpartitions for each partition) on a separate ID column. The requirement is to modify a column data type from number(10) to Varchar2(10) for one of the columns in this table. This column will be nullable. It's a 19C(19.15) oracle Exadata production database.
Date: Fri, 26 May 2023 01:21:25 +0530
Message-ID: <CAEzWdqfizFkCWHz4p1pbivepkNMRM2XJxwcL0Ckxa7o84nVVLQ_at_mail.gmail.com>
Hello Listers, We have a big table ~3.5TB in size holding ~15billion+ rows , 65 columns and its range partitioned(~200+ partition) on a date column and hash subpartition(32 hash subpartitions for each partition) on a separate ID column. The requirement is to modify a column data type from number(10) to Varchar2(10) for one of the columns in this table. This column will be nullable. It's a 19C(19.15) oracle Exadata production database.
We don't have an environment to try with similar volume , but as it looks to me Oracle will try to update each and every value of that column while modifying the data type, so that will take a long time considering the size of the table. So I wanted to understand from experts , is there any possible way here to modify the column data type faster?
Regards
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 25 2023 - 21:51:25 CEST