brspace tbreorg uncompressed tables

[mathias_s]

Hi,

i have to reorg a tablespace to a new one. The old and the target tablespace have Default table compression enabled and compress_for is set to advanced.

Reorg of the compressed tables is done with option reorgEXCL.tab and -SCT.

Now i have to reorg the uncompressed tables (still in the old tablespace). I set the compression option to no but after the reorg the tables are compressed in the new tablespace.

How can i reorg the tables uncompressed to the new tablespace?

Thank you

Mathias

[JamesZ]

Hi Mathias,

We can add 'nocompress' word expcility during reorg, the similar idea as kba ##2477068.
Let brspace stops when generated ddl statement, and where we can add nocompress to there.
Then please test, whether the table will be compressed still or not.

Best regards,
James