Hi
I have requirement to Migrate a sybase database to oracle . I were able to use sql developer migration tool to generate bcp scripts and sqlldr script to bcp out data from sybase and import data to oracle
using sqlldr successfully for normal dataypes .
I have three table which has Image column and I am having trouble in getting data out from sybase to push it to oracle .
sybase Tables name where obj_bn is the image column
cache_obj ; Sybase table
Column_name Type LengthL
----------- -------- ------
obj_parm_tx varchar 50
lst_upd_ts datetime 8
obj_bn image 16
Cache obj - Oracle Table
OBJ_PARM_TX VARCHAR2(50 CHAR)
LST_UPD_TS TIMESTAMP(6)
OBJ_BN BLOB
I am unable to export and import the usual way as I did for others ,
Is there is any workaround to copy the data .
Note: I am aware sql Developer has GUI option to copy data but this is a time consuming process . takes more than 6 hours for this table.