EM 13.4: Error adding partition: ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects
(Doc ID 2883036.1)
Last updated on AUGUST 02, 2022
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 to 13.4.1.0.0 [Release 13c]Information in this document applies to any platform.
Symptoms
In Enterprise Manager 13.4 Console Health Overview page system errors below are logged:
Error adding partition: ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects SQL: ALTER TABLE SYSMAN.EM_TT_CHG_WORK_ITEM_HIST_E ADD PARTITION "2020-09-01 00:00" VALUES LESS THAN (TO_DATE('2020-09-01 00:00', 'YYYY-MM-DD HH24:MI')) and Error during drop partitions for table: SYSMAN.EM_TT_CHG_EXCEPTIONS_E SQL: ALTER TABLE SYSMAN.EM_TT_CHG_EXCEPTIONS_E DROP PARTITION "1990-01-01 00:00" UPDATE GLOBAL INDEXES Error: ORA-14083: cannot drop the only partition of a partitioned table
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |