This documentation supports the 9.1 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

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');

Was this page helpful? Yes No Submitting... Thank you

Comments