Alter Hybrid Partition Exchange Got Error ORA-14354. (Doc ID 2966809.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

alter hybrid partition exchange got error message.

Test Case
-----------------------
CREATE TABLE TEST01
( ID VARCHAR2(32),
SDATE DATE )
EXTERNAL PARTITION ATTRIBUTES
( TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY DATA_PUMP_DIR
REJECT LIMIT 0
)
PARTITION BY RANGE (SDATE)
(PARTITION P202301 VALUES LESS THAN (TO_DATE(' 2023-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
PARTITION P202302 VALUES LESS THAN (TO_DATE(' 2023-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
);

CREATE TABLE exchange_table2301
ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY DATA_PUMP_DIR
ACCESS PARAMETERS (NOLOGFILE) LOCATION ('exchange_table2301.dmp')
)
AS SELECT * FROM TEST01 PARTITION(P202301);

ALTER TABLE TEST01
EXCHANGE PARTITION(P202301) WITH TABLEexchange_table2301;

ERROR
-----------------------
SQL> ALTER TABLE TEST01
EXCHANGE PARTITION(P202301) WITH TABLEexchange_table2301;
ALTER TABLE TEST01
*
ERROR at line 1:
ORA-14354: operation not supported for a hybrid-partitioned table

Changes

None

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.