Table reorg failed

[Former Member]

Hello experts,

we are running oracle Database reorganization with Brtools, we are on oracle 10.2 and brtools 7.1 patch 12, during Database reorganization we are getting issue errors as below, can some one help me please

BR1110W Table SAPP00.MC11VA0HDRSETUP has a LONG (RAW) column

BR1111I Reorganization of table SAPP00.MC11VA0HDRSETUP will be skipped

We have tried the re-org using offline mode, still we get back the same error...

[Former Member]

The term "offline reorganization" is a little bit confusing. I assume you mean "-m offline" when you speak about offline reorganization. This is the ALTER TABLE MOVE approach that cannot handle LONG and LONG RAW columns. Traditionally we speak about EXP / IMP ("-f tbexport", "-f tbimport") when saying "offline reorganization". This reorganization approach is able to handle LONG and LONG RAW columns.

[Madhusudank]

Note 646681 - Reorganizing tables with BRSPACE

Read this note and follow the steps given in the part III.

III. Converting the LONG fields into LOB fields online as of Oracle 10g

========================================================

You can then continue with reorganizaing tables with 'BRSPACE ONLINE'

Hope this will help.