reorg table with lob segment alos

[Former Member]

hi

guruji

how reoraganize table with lob column means i alos reorg a lob segment of that tables also i use brtool to reoragnize

nainesh suthar

[Former Member · Accepted solution]

Hi,

What database version you on ?

what SAP release ?

Mark

[Former Member · Accepted solution]

br tools 7

[Former Member · Accepted solution]

Hi,

you will have to come up with more info, some things depends on DB release and SAP release.

mark

[Former Member · Accepted solution]

hi,

select owner, table_name, column_name from dba_lobs

where segment_name = '$LOB'

alter table SAPSR3.$table enable/disable row movement;

alter table SAPSR3.$table shrink space cascade;

see you,

ferhan tekin

[Former Member · Accepted solution]

Assuming he's on 10g and ASSM

[Former Member · Accepted solution]

hi

as you requare i send information

db reles 10g

sap ecc 6.0

br tools 7.0

nainesh

[former_member204746]

read SAP note 646681, it explains the whole process.

I would also like to make a few corrections on words you use:

reoraganize ... should be reorganize

reles... should be release

alos... should be also

[Former Member]

Hi,

Yes you can...

But be aware if you come across LONG RAW tables that need reorging they need to be converted to

LOB/BLOB/CLOB which can also be done online.

But I would highly recommend you read up on it and think about it carefully as I have frequently seen documents stating performance issues post conversion..

something I found :

http://help.sap.com/saphelp_nw04s/helpdata/en/32/0d0c888839164ba4245b3ff7969c59/content.htm

Regards

Mark

Edited by: Mark Norman on Dec 2, 2009 2:09 PM