Partition maintenance failure
From: Lok P <loknath.73_at_gmail.com>
Date: Thu, 13 Jan 2022 02:20:12 +0530
Message-ID: <CAKna9VYnMKnFWB80gPVPsN-Z_W2KC5Ze9ys70qHnbRg+bPqkTg_at_mail.gmail.com>
Hello , We have a third party application in which a table was created in the past using DDL as below. And a partition maintenance jobs logic which was referring to the "high_value" column of the dba_tab_partition and it was having "to_date" in it. But we got to know , they keep on failing since past months and the high_value is now showing "timestamp" in it. Data type of the partition key column has not been changed as confirmed by the team. Can it be because of the 19C migration?
Col1 TIMESTAMP NOT NULL ,
)
PARTITION BY RANGE (PART_DATE)
(PARTITION MONTH_202008 VALUES LESS THAN (TO_DATE(' 2020-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')), PARTITION MONTH_202009 VALUES LESS THAN (TO_DATE(' 2020-10-01 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
PARTITION MONTH_202012 VALUES LESS THAN (TO_DATE(' 2021-01-01 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')))
Date: Thu, 13 Jan 2022 02:20:12 +0530
Message-ID: <CAKna9VYnMKnFWB80gPVPsN-Z_W2KC5Ze9ys70qHnbRg+bPqkTg_at_mail.gmail.com>
Hello , We have a third party application in which a table was created in the past using DDL as below. And a partition maintenance jobs logic which was referring to the "high_value" column of the dba_tab_partition and it was having "to_date" in it. But we got to know , they keep on failing since past months and the high_value is now showing "timestamp" in it. Data type of the partition key column has not been changed as confirmed by the team. Can it be because of the 19C migration?
Actually this database was on 11.2.0.4 and in the recent past it's been moved to 19C. Not able to test the behavior of the column high_value because of the absence of 11.2 dev instances. So wanted to check if anybody else encountered such an issue while migrating or is it expected to change between 11.2 and 19C?
CREATE TABLE TAB1(
ID NUMBER(13,0) NOT NULL , PART_DATE TIMESTAMP NOT NULL ,
Col1 TIMESTAMP NOT NULL ,
)
PARTITION BY RANGE (PART_DATE)
(PARTITION MONTH_202008 VALUES LESS THAN (TO_DATE(' 2020-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')), PARTITION MONTH_202009 VALUES LESS THAN (TO_DATE(' 2020-10-01 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
PARTITION MONTH_202012 VALUES LESS THAN (TO_DATE(' 2021-01-01 00:00:00',
'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')))
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 12 2022 - 21:50:12 CET