Home » SQL & PL/SQL » SQL & PL/SQL » Transfering files from one location to another location (Oracle 10g)
Transfering files from one location to another location [message #342873] Mon, 25 August 2008 07:43 Go to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

I have copy the PDF files from local directory to remote directory. Which way is best in oracle??

Can i use UTL_FILE.fcopy ,UTL_FILE.frename?? or Shell Script?

Any Built-in function available in oracle?

please share your ideas.






Re: Transfering files from one location to another location [message #342877 is a reply to message #342873] Mon, 25 August 2008 07:45 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why do you think you should use a database to do this?
Do you also use shoes to keep your hands warm in winter?
Wrong tool for the job.
Re: Transfering files from one location to another location [message #342880 is a reply to message #342873] Mon, 25 August 2008 07:47 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
As has been discussed many times just in the past week, Oracle is a Database for manipulating data, not files. UTL_FILE operates on the server, not on the client. You may want to look at WEBUTIL, but otherwise, do file manipulation at the OS level, not the database level.
Re: Transfering files from one location to another location [message #342910 is a reply to message #342873] Mon, 25 August 2008 08:30 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
So, better i can do this using Shell script right??
Re: Transfering files from one location to another location [message #342917 is a reply to message #342873] Mon, 25 August 2008 08:59 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

Can i use the DBMS_FILE_TRSNSFER function? This is my doubt.
Re: Transfering files from one location to another location [message #342934 is a reply to message #342917] Mon, 25 August 2008 10:30 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc:
Quote:
The DBMS_FILE_TRANSFER package provides procedures to copy a binary file within a database or to transfer a binary file between databases

So try it in your environment.

Regards
Michel
Previous Topic: INVALID IDENTIFIER IN JOINING SCRIPT
Next Topic: Either Joins1 or join2 but not both
Goto Forum:
  


Current Time: Fri Dec 02 20:47:29 CST 2016

Total time taken to generate the page: 0.17616 seconds