reorg of compressed table

[Former Member]

Hello,

i try to reorganize a compressed table partition with brspace, brspace use DBMS_REDEFINITION.START_REDEF_TABLE.

my question is:

- DBMS_REDEFINITION.START_REDEF_TABLE uncompressed data for reorg?

- target data will be uncompressed? if yes i have to compress it once after ?

thank you for your help

[stefan_koehler · Accepted solution]

Hello Hacene,

the reorganisation will not de-compress the table.

The interim table will be created with the same attributes / settings like the original table by brspace before running the PL/SQL procedure START_REDEF_TABLE.

You can also use the option "-ddl" to check the interim table definition.

BR*Tools documentation: http://help.sap.com/saphelp_nw70/helpdata/de/cb/376c1d44ec274daa70e5e07cfa09c6/content.htm

Regards

Stefan

[Former Member · Accepted solution]

Hello Stefan

Create Thank you for your help.