Converting the LONG fields into LOB fields online in Oracle 10g

[tahar_chettab]

Hi,

Can I use sql command: alter table <Table_name> modify ( field_name CLOB/BLON) to convert the long to lob instead to use brspace -f tbreorg -a long2lob -t "*".

Regards,

Tahar.

[former_member204746 · Accepted solution]

probably, but you should use brtools whenever possible.

I guess you have read SAP note 646681. you have read the limitations and the 30% speed decrease of converting to LOBs?