Scripts to Reorg LOB Segments

This to script are used to reorg LOB segments.

The first one will change some parameters of segment and will also shrink it so the move command will run faster.

The seccond script is the MOVE command.

Below the examples:
###############################
#####Script Pre-Reorg##########
###############################

#!/bin/ksh
sqlplus /nolog < ###" connect system/passwd@SID
show user
spool reorg_otm_18102009_30.log
select sysdate from dual;

set time on
set timing on
SET LINESIZE 150
SET PAGESIZE 100
SET HEAD OFF
SET ECHO OFF
SET TIME ON;
SET TIMING ON;


alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (freepools 1);
alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (shrink space cascade);
alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (pctversion 0);
alter table GLOGOWNER.I_TRANSMISSION modify lob (XML_BLOB) (retention);


spool off
exit;
###EOF - Remove '###'

###############################
#####Script Reorg##############
###############################
#!/bin/ksh
sqlplus /nolog <### connect system/passwd@SID
show user
spool reorg_otm_18102009_32.log
select sysdate from dual;

set time on
set timing on
SET LINESIZE 150
SET PAGESIZE 100
SET HEAD OFF
SET ECHO OFF
SET TIME ON;
SET TIMING ON;

ALTER TABLE GLOGOWNER.I_TRANSMISSION move partition INBOUND2 LOB (XML_BLOB) STORE AS (TABLESPACE LOB4) parallel 8 nologging;

spool off
exit;
###EOF - Remove '###'