Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Modify external file will cause External Table empty
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