Skip to Content
avatar image
Former Member

TST03 table reorg

Hi All,

We have 4 system landscape in our system envi. I tried to test the table reorg for TST03 table using brtools.

In FX1 system (Testing system), i can't able to reorg. It will ended with errors cause of long row

BR0280I BRSPACE time stamp: 2010-01-19 16.18.59

BR1108I Checking tables for reorganization...

BR1110W Table SAPFX1.TST03 has a LONG (RAW) column

BR1111I Reorganization of table SAPFX1.TST03 will be skipped

Where as one more system UT1(Testing system) i can able to reorg. There are no errors. It has completed successfully.

I have compare the table version management in both system but i didnt find any difference.

Can you pls help on this issue, why i am not able to do the table reorg.

Thanks/Regards,

Bhanu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 19, 2010 at 10:20 AM

    Hi,

    you need to convert the long to lob fields. This can be done online by brtools.

    You can find the convert in brtools in 3 - Segment management, 1 - Reorganize tables, 3 ~ Reorganization action (action), long2lob.

    After the convert it is possible to do the reorganisation.

    Regards,

    Lukas

    Edited by: Lukas Klenk on Jan 19, 2010 11:23 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2010 at 10:35 AM

    Hi,

    Thanks for your advice. Can you pls let me know why i can't able to do reorg.

    1. In FX1 testing system - can't perform the table reorg (TST03)

    2. In UT1 testing system - Able to perform the table reorg.(TST03)

    The table i have compared in two systems. All fileds are same . only thing is the tablespace is in FX1 Manual and UT1 is Auto.

    Is it so becuase of the AUTO or Manual, i am not able to perform the table reorg?

    Can you pls advice on this issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Is it so becuase of the AUTO or Manual, i am not able to perform the table reorg?

      No, as the others say it is because of the datatype LONG.

      Check both systems, FX1 will look like this:

      SQL> desc tst03
       Name                                      Null?    Type
       ----------------------------------------- -------- ----------------------------
       DCLIENT                                   NOT NULL VARCHAR2(3)
       DNAME                                     NOT NULL VARCHAR2(20)
       DPART                                     NOT NULL NUMBER(5)
       DROWNO                                    NOT NULL NUMBER(10)
       DDATALEN                                  NOT NULL NUMBER(5)
       DCONTENT                                           LONG RAW

      While UT1 looks like this:

      SQL> desc tst03
       Name                                      Null?    Type
       ----------------------------------------- -------- ----------------------------
       DCLIENT                                   NOT NULL VARCHAR2(9)
       DNAME                                     NOT NULL VARCHAR2(60)
       DPART                                     NOT NULL NUMBER(5)
       DROWNO                                    NOT NULL NUMBER(10)
       DDATALEN                                  NOT NULL NUMBER(5)
       DCONTENT                                           BLOB

      Notice the different type on the DCONTENT field.

      Cheers Michael