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

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

Case 3 - Displaying SQL statements only

The p_change_LOB_storage stored procedure runs SQL statements to apply changes to large objects (LOBs). To display those SQL statements without applying changes to the LOBs, execute the procedure as specified in the following table.

Task

SQL statement

Display the SQL statements that the stored procedure will execute to change the LOBs in table T1866 from out-row to in-row.

Set serveroutput on
exec p_change_LOB_storage(p_in_row =>'Yes',p_dest_tablespace =>'ARSYSTEM', p_table_name =>'T1866', p_generate_SQL_only='Yes');

Display the SQL statements that the stored procedure will execute to change all LOBs from out-row to in-row and move them to tablespace AR_LOB.

Set serveroutput on
exec p_change_LOB_storage(p_in_row =>'Yes',p_dest_tablespace =>'AR_LOB', p_generate_SQL_only='Yes');

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

Comments