Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: plsql/filesystem
All you need to use is SQL Plus:
Host path\filename newpath\filename
One thing I found: you need to put the path (even if it is the same) in both the old file and the new file or else Oracle will move it to the default directory.
Also, If this is for an archiving process, I use SQL Plus to find the current date and name the file with the date:
>col today newvalue today1 >select to_char(sysdate,'yyyymmdd') from dual; >host c:\winnt\file.txt c:\winnt\&today1..txt
You do need to two decimal points in the host command new file name.
Hope this helps.
Erbug Celebi wrote in message <3587ABC4.546C16D9_at_cs.deu.edu.tr>...
>Hi All,
>
>Im using Oracle8.0.4 enterprise edition on Solaris2.6.
>And, I need to do some work from pl/sql on filesystem.
>For example, I want to move a file (in filesystem) from a
>directory to another one by using pl/sql.
>Can anybody tell me how to do this without using Pro*C/C++.
>
>Thanks in advance.
>
>--
>*************************************************************************
>
>Erbug Celebi |
>Department of Computer Engineering | Email: celebi_at_cs.deu.edu.tr
>
>Dokuz Eylul University |
>celebi_at_acm.org
>Bornova,Izmir |
>35100, TURKEY |
>*************************************************************************
>
>
>
Received on Fri Jun 19 1998 - 00:00:00 CDT