exchange partition; drop col from compressed table; ORA-14097: column type or size mismatch

drop_col_exch_part_issue.sql

cl scr 

set echo on

drop table test_part_tab purge;
drop table test_exch_tab purge;
drop table test_exch_tab_no_c2 purge; 

create table test_part_tab (
    pkey int,
    c1 int,
    c2 int
)
-- table has to be compressed
row store compress basic
partition by range(pkey) (
    partition p0 values less than (1),
    partition p1 values less than (2) 
);

create table test_exch_tab as select * from test_part_tab;

-- so far so good! 
alter table test_part_tab exchange partition p0 with table test_exch_tab;

-- drop a dummy column
alter table test_part_tab drop column c2; 

-- it is still there, not dropped but marked as unused instead, 
-- because the table is compressed
select column_name from user_tab_cols where table_name = 'TEST_PART_TAB';

create table test_exch_tab_no_c2 as select * from test_part_tab;

-- ORA-14097
alter table test_part_tab exchange partition p1 with table test_exch_tab_no_c2;

exit