Case 2 - Applying changes to LOBs only in a specified table
To apply changes to LOBs only in specified tables, execute the procedure as specified in the following table.
Task | SQL statement |
|---|---|
Change the LOBs in table T1866 from out-row to in-row, and keep them in tablespace ARSYSTEM. | exec p_change_LOB_storage(p_in_row =>'Yes',p_dest_tablespace =>'ARSYSTEM', p_table_name =>'T1866'); |
Change the LOBs in table T1866 from out-row to in-row, and move them to tablespace AR_LOB. | exec p_change_LOB_storage(p_in_row =>'Yes',p_dest_tablespace =>'AR_LOB', p_table_name =>'T1866'); |
Move LOBs in table T1866 to tablespace AR_LOB without changing the storage option. | exec p_change_LOB_storage(p_in_row =>Null,p_dest_tablespace =>'AR_LOB', p_table_name =>'T1866'); |
Change LOBs in table T1866 from in-row to out-row, and keep them in tablespace ARSYSTEM. | exec p_change_LOB_storage(p_in_row =>'No',p_dest_tablespace =>'ARSYSTEM', p_table_name =>'T1866'); |