In SQL*Plus I can insert a record with timestamp fields as follows:

insert into Table_Name values

('014867514',

TIMESTAMP'2003-04-03 08:37:43.593',

'ADAPTER,CONNECTOR,FIBER OPTIC',

'A00000039.jpg',

TIMESTAMP'2007-11-27 11:20:10.867' );

So, I am thinking there has to be some intermediary step between selecting from SQL Server and inserting into Oracle. My best guess is that SQL Server doesn't recognize the Oracle timestamp data type so it interprets it as something else. If that is the case, then I am thinking that using CONVERT might work, but I have no idea what SQL Server data type to CONVERT to.

Anything is possible: it's just a matter of are you smart enough to figure it out. This one is testing me!