DATABASE REORGANIZATION

[mrio_tavaresalmeida]

I'm planning to reorganize my Oracle database according to SAP note 646681 Reorganizing tables with BRSPACE.

On second chapter of the referred note it says that tables with <b>LONG and LONG RAW fields cannot be reorganized</b>.

How can i identify with tables have LONG RAW fields?

Many thanks,

[mrio_tavaresalmeida · Accepted solution]

Thanks a lot for your reply.

The referred document is very good and can help a lot to understand that as for Oracle 10g i can convert LONG RAW fields.

My Database is on version 9.2 so, wright now, i cannot convert LONG RAW fields to CLOB and BLOB.

I insist, is there any way to identify witch tables have LONG RAW fields?

Once again many thanks for cooperation,

Mário Almeida

[Former Member · Accepted solution]

Mario,

I can ans u at oracle level

sql>select owner,table_name,data_type from all_tab_columns

where data_type IN ('LONG','LONG RAW');

Result => all tables with LONG RAW fields.

Regards

Vinod

[mrio_tavaresalmeida · Accepted solution]

Many Thanks Vinod,

Thats exactly what i want.

Cheers,

M.A.

[Former Member]

this may help you, follow http://help.sap.com/saphelp_nw2004s/helpdata/en/11/06a53fa6503c17e10000000a114084/frameset.htm

Cheers,

-Sunil