Compress partitionned table with dbms_redefinition
Bonjour,
I am struggling with a strange behavior when trying to compress a partitionned table using dbms_redefinition.
In my dev environment, when using the following :
BEGIN
DBMS_REDEFINITION.REDEF_TABLE(
uname => 'MY_SCHEMA',
tname => 'MY_TABLE',
table_compression_type => 'ROW STORE COMPRESS ADVANCED');
END;
All partitions gets compressed and they all show the ROW STORE COMPRESS ADVANCED status.
But when trying the same thing in my prod environment, only the first partition gets compressed and all other partitions remains uncompressed.
In both case, I'm in Oracle 12c (12.1.0.2.0) and using the automatic partitionning (same code, same table's scripts).
The only difference here is that dev is standalone while prod is RAC.