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...

[anindya_bose]

BRSPACE skips tables with LONG RAW field. SO you can not reorganize tables with LONG RAW field with BRTOOLS.

Either you can change LONG RAW to LOB ( LONG LOG Migration, note number has been provided in the postings above). But this SAP notes also say that changing to LOB might cause performance problem. or you can simply do export/import method.

1. Brtools->Segment Management->Export Tables--->Tablename, Tablespace names,dump directory etc have to be specified.

2. Then Truncate the table....from Oracle level by command "Truncate table <tablename>;

you can see now the count is zero.

3. In the third step, import table from its dump file. BRTOOLS has this option also.

Check the link below for more information.

Best Regards

Anindya

Edited by: Anindya Bose on Aug 25, 2009 5:55 PM