SXMSCLUP and SXMSCLUR

[Former Member]

Hello SAP Basis and oracle admins. I'm have one question and do not know how can i handle it )

In XI system i see this two tables are very big (SXMSCLUP and SXMSCLUR The deleting and archiving jobs are planned and executed.).

I can't understand are this tables have the LONG or LONG RAW fields,

and can i use BRSPACE to reorganize this tables online ?

The select statment does't shows this tables? but may be this are wrong ?

statment --> select table_name from dba_tab_columns where DATA_TYPE like 'LONG%';

Also the Biggest in DB are the LOBSEGMENTS related to this tables (like this SYS_LOB0000025912C00008$$ )

how i can reorganize their ?

Oracle are 10.2.0.4

Thanks and regards.

[JPReyes · Accepted solution]

Read,

Note 646681 - Reorganizing tables with BRSPACE

Theres plenty of info there

Regards

Juan

[Former Member]

Hello Sergo,

not sure if I correctly understood your problem.

If you want to find out whether or not a table has LONG or LONG RAW columns,

the easiest way imho is describe command in sqlplus, for example:

desc SXMSCLUP

In my system it shows BLOB, but no LONG.

regards

[Former Member]

Thanks Joe Bo. The desc is really easiest way ...

Thanks Juan i'm read this note before, i'm do it many times, but I have not met before with LOBSEGMENT.

I'm try reorganize this table on test server and this reorganize the LOBSEGMENT related to this table to.

Regards.