Hi, I used bcp to extract two rows of data into a file from a Sybase database. One of the columns in each row containts blob data. I'm not trying to use sqlldr to insert the data from the file into an Oracle database, but I keep getting this message: Record 1: Rejected - Error on table BLOBTEST, column TXDATA. Field in data file exceeds maximum length Record 2: Rejected - Error on table BLOBTEST, column TXDATA. Field in data file exceeds maximum length Ideas? Hints?

*I'm NOW trying to use sqlldr. Typo, sorry.

wvr, Never used Oracle or Sybase, but it looks like you're trying to put too much data into the Oracle field. Am I correct in assuming that TXDATA is the Oracle BLOB field the Sybase BLOB is being loaded into? Just looked in my O'Reilly SQL in a Nutshell book and it says that the Oracle BLOB data type takes a value "...between 8 and 128 terabytes, depending on the database block size." This should be more than sufficient for _any_ field being imported from the Sybase database. Heh, maybe even the whole Sybase database itself. ;) Are you sure that the TXDATA field is a BLOB data type? Have you checked to make sure that the order of fields are the same in both databases? (i.e. the BLOB field is field #4 in both tables??) Could you show the table layouts from both Sybase and Oracle? Just some thoughts, Stephen "Live long and PROGRAM......or at least do _something_ with all that time...!"