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]

First of all, thanks for all the useful advise!

Does that mean for me to re-org the table using offline mode, i have to perform the import/export steps first?

If yes for above, why is the method 're-org in offline mode' not working if the import/export steps is not perform?

Appreciate the replies, thanks again!

[anindya_bose]

Mostly two methods are being used for reorganization

One is Online reorganization.

A) Brtools->Segment Management->Reorganize Tables ( other options are self explanatory)

Other is Exp/IMPOrt

B)

Steps 1) Brtools->Segment Management->export tables ( it will crate a dump file expdat.dmp)

Steps 2) from oracle level you have to truncate the table ..Command " truncate table <tablename>;"

Then run "select count(*) from SAP_CHEMA.TABLENAME; " It should show zero entries

Steps 3) Brtools>Segment Management->Import Table ( it will ask for the dump file path)

Please read my previous post and the notes I meantioned there before starting.

Best Regards

Anindya

[Former Member]

reorg in offline mode... SAP must be down to start this.

please provide exact error message you get.

[Former Member]

Hi,

Does that mean for me to re-org the table using offline mode, i have to perform the import/export steps first? ->Yes,Do the reorganization using offline method.For doing the reorganization,export the tables and import the tables accordingly.

If yes for above, why is the method 're-org in offline mode' not working if the import/export steps is not perform?->Reorg in offline method means export/import method.

Thanks and Regards,