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'); |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*