Is "long2lob" no harm to my SAP ?

[Former Member]

Hello,

I need to do table reorganization on my SAP tables but some of them have LONG or LONG RAW columns, eg, DDNTF, VBDATA, ED140, IWB0CONT1.

Although I could use BRTOOLS, long2lob to convert them to BOLOB and then did table reorgan. on them, can anybody tell me is "long2lob" no harm to my SAP ?

"long2lob" is a irreversible process, any body have experiences on using it ?

After having long2lob, can I use my SAP as before ?

My Oracle is Oracle 10g, BRTOOLS is 7.0.

[stefan_koehler]

Hello Ming,

you can also reorganize your tables and keep the LONG / LONG RAW columns, but then you can only perform an offline reorganization.

Go for the conversion to LOB ... it's no big deal and working fine. LOB is the "standard" right now, so nearly anybody with a newer SAP release or migrated SAP systems is using LOBs.

Regards

Stefan

[Former Member]

Thanks.

[Former Member]

Hi Ming,

>> Although I could use BRTOOLS, long2lob to convert them to BOLOB and then did table reorgan. on them, can anybody tell me is "long2lob" no harm to my SAP ?

It will not harm on SAP system. But, it would be good to check the notes, below;

Note 1223716 - ORA-932 error after LONG to LOB conversion

Note 835552 - Oracle Database 10g: LONG-LOB migration

Note 1514200 - Possible dataloss after long to lob conversion

>> "long2lob" is a irreversible process, any body have experiences on using it ?

Technically, it is possible, but not using by brtools

>> After having long2lob, can I use my SAP as before ?

Yes. There's no problem with it.

Best regards,

Orkun Gedik

[Former Member]

Thanks.