Home » SQL & PL/SQL » SQL & PL/SQL » Uploading csv files with different names on periodical basis. (Oracle Enterprise Edition 11g R2)
Uploading csv files with different names on periodical basis. [message #661223] Sat, 11 March 2017 02:49 Go to next message
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
Senior Member
Hi All,

I've a scenario where we receive files on clients FTP on every 30 minutes. We need to download these files from there and upload it's data to database tables.

Downloading is done by Java code at present. I want to know the correct approach to upload their data to database tables as the file naming convention is FILENAME_DDMMYYYY_HH24MISS.csv

Every time we receive file the name will be different. Although I can create external table for the same and alter LOCATION parameter before uploading file's data to database.

I just wanted to know is there any other better approach to achieve this?

Thanks & Regards
Manoj
Re: Uploading csv files with different names on periodical basis. [message #661225 is a reply to message #661223] Sat, 11 March 2017 02:57 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Do you want to create a file watcher?
http://docs.oracle.com/database/122/ADMIN/scheduling-jobs-with-oracle-scheduler.htm#GUID-B17B0307-45B6-4251-B554-923785745E78
Re: Uploading csv files with different names on periodical basis. [message #661276 is a reply to message #661225] Mon, 13 March 2017 21:02 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
There are ways to get lists of files in a directory from within Oracle but I need to know what's your Oracle version. As different options work in different versions. Please paste the result of

Select * from v$version;

[Updated on: Tue, 14 March 2017 07:43]

Report message to a moderator

Re: Uploading csv files with different names on periodical basis. [message #661278 is a reply to message #661276] Mon, 13 March 2017 21:07 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What is OS name & version?
Previous Topic: Help me with error Compilation unit analysis terminated (2 threads merged by bb)
Next Topic: How to find highest salary ?
Goto Forum:
  


Current Time: Thu Mar 28 13:31:43 CDT 2024