Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: External Table problem

Re: External Table problem

From: <Tony.Adolph_at_o2.com>
Date: Wed, 30 Aug 2006 13:41:16 +0200
Message-ID: <OF43EB7F39.8883E476-ONC12571DA.003E847D-C12571DA.0040340D@o2.com>


Hi Raj,

Its a possibility I guess. But I'd have to code it java and I'd rather "tweek" the external rtable definiation if posssible.... if not then I guess its back to the code!

Thnaks for the feedback.

Tony Adolph
Room A470
IS-SD ES&I Middleware - GDF
o2 (Germany) GmbH & Co.OHG
Georg Brauchle-Ring 23-25, D80992 München Tel +49 (0)89 2442 5920
Mobil +49 (0)179 509 0840

rjamya <rjamya_at_gmail.com>
30.08.2006 13:12

To
adolph.tony_at_tiscali.de
cc
oracle-l_at_freelists.org, tony.adolph_at_o2.com Subject
Re: External Table problem

can you run your file through unixtodos and get rid of '^M' and then jut specify record delimiter as NEWLINE ??

Raj

On 8/30/06, adolph.tony_at_tiscali.de <adolph.tony_at_tiscali.de> wrote:
>
> The records are delimited by ^M (as they are created on the NT box).
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 30 2006 - 06:41:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US