Home » SQL & PL/SQL » SQL & PL/SQL » Read csv File from Shared Location (Oracle 10G, Windows XP)
icon7.gif  Read csv File from Shared Location [message #594565] Fri, 30 August 2013 03:02 Go to next message
Messages: 31
Registered: March 2007
Location: Pune,India
Hi friends,
I want to upload csv file from share location(another host) & store data in table,Please suggest how to do it.
Re: Read csv File from Shared Location [message #594583 is a reply to message #594565] Fri, 30 August 2013 07:45 Go to previous messageGo to next message
Messages: 4758
Registered: February 2005
Location: East Coast USA
Senior Member
Copy it first to your DB server and then depending on what you mean by upload, either use external table, sql loader or utl_file to do it.
Re: Read csv File from Shared Location [message #594619 is a reply to message #594583] Sat, 31 August 2013 03:09 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, you could try to use that CSV file as an external table which reads data from a (file system) directory whose (Oracle) directory (object) is created using UNC (Universal Naming Convention). I struggled with it some time ago; have a look, if you are interested in some more reading.
Previous Topic: creating a temporary table
Next Topic: How to scheduling a job from 8 am to 8 pm
Goto Forum:

Current Time: Sat Jul 22 19:59:07 CDT 2017

Total time taken to generate the page: 0.25767 seconds