Database Administration (MOSC)

MOSC Banner

Compress partitionned table with dbms_redefinition

edited Jul 20, 2016 5:06AM in Database Administration (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center