There is a difference between source and target tables' data type.
For example:
Source: ACTIVATION_TIMESTAMP TIMESTAMP(6),
Target: ACTIVATION_TIMESTAMP Date,
or
Source: DEVICE_ID_TYPE_TS TIMESTAMP(6) WITH TIME ZONE,
Target: DEVICE_ID_TYPE_TS TIMESTAMP(6),
Target: DEVICE_ID_TYPE_TS Date,
or
Source: DEVICE_ID_TYPE_TS TIMESTAMP(6) WITH TIME ZONE,
Target: DEVICE_ID_TYPE_TS TIMESTAMP(6) WITH LOCAL TIME ZONE,
ORA-01830 date format picture ends before converting entire input string
Cause: A valid date format picture included extra data. The first part of the format picture was converted into a valid date, but the remaining data was not required.
Action: Check the specifications for date format pictures and correct the statement
Workaround:
1. Since modified column with data may not work, the offended column should be nullified first.
i. create table temp table as select pk, plus columns that need to be modified.
ii. update table set those columns to null
iii. alter table modified column to match with source table data type
iv. update table set column = temp_table.column where pk = temp_table.pk.
2. Recreate target table with the correct data type and use SELECT AS INSERT from old table to new table.
3.Using oramsglist to keep post mosing forward. This workaround will cause table out of sync and resync target table is needed.
4. Disable target table to have post moving forward. This workaround will cause table out of sync and resync target table is needed.
