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

Home -> Community -> Usenet -> c.d.o.server -> Re: Modify external file will cause External Table empty

Re: Modify external file will cause External Table empty

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Tue, 20 Jun 2006 15:09:52 GMT
Message-ID: <4dUlg.7835$nS5.4611@trnddc07>


Resant wrote:
> Hi all,
> I have a strange problem. I have a csv file that is used as source file
> in External Table (ET).
> When I try to modify the file, and select ET will caused no rows
> returned. But when I delete one of the column in CSV file, the ET works
> ok.
> If I create new CSV file from notepad, it cause ET was empty too. The
> ET only works, if CSV file generated from my Excel Macro.
> Any idea what happen actually?
>
> Thanks,
>
> Resant
>

Please post a sample of the CSV file, and the DDL for the external table. In particular the access parameter section. Received on Tue Jun 20 2006 - 10:09:52 CDT

Original text of this message

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