Metrics Timeseries Column Redifinition

CREATE TABLE centralcdb_customer_metrics_timeseries_temp$ (TIMESERIES_ID VARCHAR2(256), METRICS_ID NUMBER, VALUE NUMBER, TS TIMESTAMP(6), LABEL_NAME VARCHAR2(256));

BEGIN
FOR i IN 1 .. 25000000 LOOP
    INSERT INTO centralcdb_customer_metrics_timeseries$ VALUES (65, '0', '12-MAY-22 01.46.00.000000 AM', 'guid_DE6CEB2B3FCB2EF4E053DD78F80AE335', '2e36bcf3-ba9a-4dc2-833e-bd66a76e7085');
 END LOOP;
COMMIT;
END;
/

DECLARE

l_colmap VARCHAR2(200) :=
q'{TIMESERIES_ID, METRICS_ID, TO_NUMBER(VALUE) AS VALUE, TS, LABEL_NAME}';

BEGIN

DBMS_REDEFINITION.ABORT_REDEF_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp$'
);

DBMS_REDEFINITION.START_REDEF_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp$',
   col_mapping => l_colmap,
   options_flag => DBMS_REDEFINITION.CONS_USE_ROWID
);

DBMS_REDEFINITION.SYNC_INTERIM_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp$'
);

DBMS_REDEFINITION.FINISH_REDEF_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp$'
);

END;
/

BEGIN
FOR i IN 1 .. 25000000 LOOP
    INSERT INTO centralcdb_customer_metrics_timeseries$ VALUES (65, 0, '12-MAY-22 01.46.00.000000 AM', 'guid_DE6CEB2B3FCB2EF4E053DD78F80AE335', '2e36bcf3-ba9a-4dc2-833e-bd66a76e7085');
 END LOOP;
COMMIT;
END;
/

CREATE TABLE centralcdb_customer_metrics_timeseries_temp2$ (TIMESERIES_ID VARCHAR2(256), METRICS_ID NUMBER, VALUE VARCHAR2(256), TS TIMESTAMP(6), LABEL_NAME VARCHAR2(256));

DECLARE

l_colmap VARCHAR2(200) :=
q'{TIMESERIES_ID, METRICS_ID, TO_NUMBER(VALUE) AS VALUE, TS, LABEL_NAME}';

BEGIN

DBMS_REDEFINITION.ABORT_REDEF_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp2$'
);

DBMS_REDEFINITION.START_REDEF_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp2$',
   col_mapping => l_colmap,
   options_flag => DBMS_REDEFINITION.CONS_USE_ROWID
);

DBMS_REDEFINITION.SYNC_INTERIM_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp2$'
);

DBMS_REDEFINITION.FINISH_REDEF_TABLE (
   uname => 'admin',
   orig_table => 'centralcdb_customer_metrics_timeseries$',
   int_table  =>  'centralcdb_customer_metrics_timeseries_temp2$'
);

END;
/