BLOB and NCLOB re-orgainization using brtools in oracle 11g.

[Former Member]

Hi All,

I need to know whether we can carry out re-organization of tables having field type  BLOB,NCLOB  using BRTOOLS in Oracle 11g. If yes, is there any SAP Notes giving details for the same. Any sap note saying it is possible to do online re-organization of tables having above two data type.

Please advice.

Regards

Deepak

[JPReyes]

Hi Deepak,

Read, SAP Note 646681 - Reorganizing tables with BRSPACE

Regards, Juan

[Former Member]

Hi Deepak,

LOB filed types shouldn;t be an issue. Issue is around LONG/LONG RAW field types which need to be converted to LOB if DB >= Oracle 10g in case of an online re-org.

Apart from the note suggested by Juan you can also check 541538 and 835552.

Regards.

Ruchit.