My Oracle Support Banner

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

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution
References


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