Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server Image to Oracle

350917Oct 7 2002

I'm converting SQL Server Tables to Oracle using MWB 9.2. The tables contain images (data type "image"). I get the following error from the MWB generated scripts:

SQL*Loader-309: No SQL string allowed as part of DISPLAY_IMAGE field specification

The column definition in the .ctl file is:

DISPLAY_IMAGE NEXT ***** CHARACTER
Maximum field length is 2000000
Terminator string : '<ec>'
SQL string for column : "HEXTORAW (:DISPLAY_IMAGE)"

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2002

Added on Oct 7 2002

#database-and-application-migrations

1 comment

637 views