Asset Suite / PassPortGeek

Create table TIDAPIRR_TMP with column BO_SEGMENT_DATA of data type LONG (deprecated as of Oracle 10G) to CLOB.

Add database trigger to table TIDAPIRR such that insert is written to new table. 20101117 No this won't work as trigger cannot reference LONG column.

Copy data to TIDAPIRR_TMP

Insert into passport.tidapirr_tmp
(Select int_request_id, .... to_lob(bo_segment_data) from passport.tidapirr);