Home » SQL & PL/SQL » SQL & PL/SQL » get name of files and copy this files
get name of files and copy this files [message #267470] Thu, 13 September 2007 06:57 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all
i use oracle 10g and windows 2003.
how can i get name of all file in folder and how can i copy this files to anther folder ?
thanx
Rafeek

[Updated on: Thu, 13 September 2007 06:58]

Report message to a moderator

Re: get name of files and copy this files [message #267471 is a reply to message #267470] Thu, 13 September 2007 07:06 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd use Windows Explorer.

Do you plan to involve Oracle in doing this job? If so, why?
Re: get name of files and copy this files [message #267485 is a reply to message #267471] Thu, 13 September 2007 08:05 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

If you are doing it just for gathering knowledge then try it with UTL_FILE.
For details see this link UTL_FILE

Cheers
Souemen
Re: get name of files and copy this files [message #267496 is a reply to message #267485] Thu, 13 September 2007 09:03 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
I would love to see how you get utl_file to give you a list of all files in an OS directory and then to copy them to another directory. Any chance you could give us a little demo?
Re: get name of files and copy this files [message #267602 is a reply to message #267485] Thu, 13 September 2007 18:01 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all
thax .
i want to get the names of all files in in folder ('c:/r')
but i not known this name of this file ?
Re: get name of files and copy this files [message #267603 is a reply to message #267470] Thu, 13 September 2007 18:08 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
I'll repeat Littlefoot's answer.
I'd use Windows Explorer.

Do you plan to involve Oracle in doing this job? If so, why?

If you intend to use Oracle, then you are using the wrong tool for the task at hand.

The best tool for meeting the requirements is part of the Operating System collection of utilities.
Re: get name of files and copy this files [message #267604 is a reply to message #267603] Thu, 13 September 2007 18:30 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
yes i plan to involve Oracle in doing this job.
Re: get name of files and copy this files [message #267605 is a reply to message #267604] Thu, 13 September 2007 18:33 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check here.
Previous Topic: Ref Cursor in DB-Link
Next Topic: Data transfer (merged)
Goto Forum:
  


Current Time: Sun Dec 04 14:51:17 CST 2016

Total time taken to generate the page: 0.05835 seconds