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 1 - Applying changes to all LOBs

To apply changes to all LOBs, execute the procedure as specified in the following table.

Task

SQL statement

Change all LOBs 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');

Change all LOBs 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');

Move LOBs to tablespace AR_LOB without changing the storage option.

exec p_change_LOB_storage(p_in_row =>Null,p_dest_tablespace =>'AR_LOB');

Change all LOBs 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');

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

Comments