TST03 table reorg

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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.

[anindya_bose]

Hi

You can not reorg table with LONG or LONG RAW field via BRTOOLS. FOr oracle database you can simply export and import table.

You could check the thread below. Please read the thread and notes mentioned there carefully before doing reorganization.

Regards

Anindya

Edited by: Anindya Bose on Jan 19, 2010 4:12 PM

[Former Member]

Hi,

perhaps you did an offline reorg on your test system (or the fields were already converted in the past)?

It is only possible to reorg tables online without long fields (see also note 541538 and 646681).

Regards,

Lukas

[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