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 -> Sometimes Select External Table from CSV File Return No Rows

Sometimes Select External Table from CSV File Return No Rows

From: Resant <resant_v_at_yahoo.com>
Date: 21 Aug 2006 22:57:03 -0700
Message-ID: <1156226223.335656.77300@p79g2000cwp.googlegroups.com>


Sori, I've to post this problem again in this forum, 'cause I didn't get satisfied answer.
My problem is : 10id\fifi.soekianto client that submit their data in CSV file to central
database. Then I use external table to get the data. It's works fine at all client except one!
I can't select the external table from that client's CSV. The table show no returned rows.
But when I open the CSV files and save directly without change anything, the external tables can show the data. I've check Excel version already and it's the same as other client. What should I do? Any clue?

Thank you

Resant Received on Tue Aug 22 2006 - 00:57:03 CDT

Original text of this message

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