Skip to Main Content
Forums

SQL & PL/SQL

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!

How to handle -Carriage return '^M' -while using external tables in oracle?

userP5Jun 23 2009 — edited Jun 24 2009
I have a external table in Oracle server installed on SOLARIS server. I want to load a file (generated on windows machine) into this external table but load fails due to carriage return character '^M'.
If I remove the carriage return characters , it works fine and my external table gets populated properly.

How should I handle carriage return characters ?

Edited by: userPrasad on Jun 23, 2009 5:06 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2009
Added on Jun 23 2009
4 comments
1,302 views