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
sumedh7
Messages: 30
Registered: March 2007
Location: Pune,India
Member
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
joy_division
Messages: 4503
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
Littlefoot
Messages: 19473
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: Thu Aug 21 03:46:11 CDT 2014

Total time taken to generate the page: 0.08713 seconds