Purge Partition Fails With ORA-28665

(Doc ID 2415335.1)

Last updated on JULY 06, 2018

Applies to:

Oracle Communications Order and Service Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.

Goal

On : OSM 7.3.1.0.0 version, Purging

The OSM purge partition operation fails with an ORA-28665 error.

We were trying to run purge_partitions for the very first time on a test environment and we come across this by performing the following steps.:

export with expdp from PP2

exec om_exp_imp_util_pkg.purge_orders

exec om_exp_imp_util_pkg.purge_model

exec om_exp_imp_util_pkg.pre_impdp_setup

import with impdp on IT

exec om_exp_imp_util_pkg.post_impdp_setup

execute om_part_maintain.setup_xchg_tables(3);

execute om_part_maintain.purge_partitions( a_online => false, a_delete_before => trunc(to_date('01/01/2018', 'MM/DD/YY')), a_order_states => om_new_purge_pkg.v_closed_orders, a_order_id_lt => 1000001);

We received the following error:

Error starting at line : 144 in command -
BEGIN om_part_maintain.purge_partitions( a_online => false, a_delete_before => trunc(to_date('01/01/2018', 'MM/DD/YY')), a_order_states => om_new_purge_pkg.v_closed_orders, a_order_id_lt => 1000001); END;
Error report -
ORA-28665: table and partition must have same compression attribute
ORA-06512: at "ORDERMGMT.OM_PART_MAINTAIN", line 6906
ORA-06512: at line 1
28665. 00000 - "table and partition must have same compression attribute"
*Cause: User attempted to EXCHANGE a compression enabled
  partition with a compression disabled table or vice versa
  OR the # of columns compressed is different for table and partition
*Action: Make sure the compression attributes match
  If they don't, fix it using ALTER TABLE MOVE [PARTITION] COMPRESS

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms