How to convert Long Raw to LOB online

Now i’ll show you how to convert Long Raw (LRAW) to LOB online. You can after that do table reorg online once you’ve converted any LRAW field to LOB field. You can do the conversion using brspace. Here I use Oracle 11.2 and brspace 7.00.

You can check your table contain LRAW field or not from ABAP transaction SE11 (ABAP Dictionary).

More information about LRAW to LOB conversion can be read in SAP Note 1431296 – LOB conversion and table compression with BRSPACE 7.20.

If you don’t do the conversion you can’t do online reorg, see picture below.

How to convert Long Raw to LOB

To do the conversion:
1. Call command brspace for table you want to convert.
Example #brspace -u / -f tbreorg -t USH12.

2. Choose option convert Long RAW fields to LOBs

How to convert Long Raw to LOB online Pic 1

3. Make sure reorganization action long2lob is chosen

How to convert Long Raw to LOB online Pic 2

4. Continue to next screen

How to convert Long Raw to LOB online Pic 3

5. Wait until the conversion finish

How to convert Long Raw to LOB online Pic 4

6. See for any error message happen, and repeat the process after you fix the cause.

How to convert Long Raw to LOB online Pic 5
To get complete reference about SAP Database Administration with Oracle you can read this book.
 

 

Leave a Reply