Skip to Content
author's profile photo Former Member
Former Member

Is "long2lob" no harm to my SAP ?

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 22, 2011 at 08:54 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2011 at 09:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.