How to load data with funny characters
Posted by: Boyan Biandov
Date: April 09, 2010 11:25AM

I need to load text file into a table but there are 2 characters that cause problems:

@ and \

Modifying the source so that those are escaped properly is out of the question - we are talking massive amount of data.

Isn't there another way to wire the load statement so that @ and \ are imported properly into the table.

At present @ causes the string to end so I only get the text prior to @ imported. The \ is a whole another story....

Thanks
~B

Options: ReplyQuote


Subject
Written By
Posted
How to load data with funny characters
April 09, 2010 11:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.