How to create folder in disk using pl/sql
Shahadat
can any guru tell me how can i create folder (c:\test\test1) in my disk
using oracle pl/sql?
please give me some adive.
thanks,
shahadat
Eric de Redelijkheid
SQL>! mkdir c:\test\test1
Mind the exclamation mark "!". What you actually do, is to give a
operating system command after the "!".
Rene Nyffenegger
> Anno Domini 7-5-2005 7:10, Shahadat sprak aldus:
>
>>Hi,
>>
>>can any guru tell me how can i create folder (c:\test\test1) in my disk
>>using oracle pl/sql?
>>
>>please give me some adive.
>>
>>thanks,
>>
>>shahadat
>>
>>
>>
> SQL>! mkdir c:\test\test1
The OP was asking to create the directory with PL/SQL, not
with SQL*Plus.
--
Rene Nyffenegger
http://www.adp-gmbh.ch/
Lewis C
Check out the CREATE DIRECTORY command in the reference manual.
Lewis
-----------------------------------------------------------
Lewis R Cunningham
Author, ItToolBox Blog: An Expert's Guide to Oracle
http://blogs.ittoolbox.com/oracle/guide/
Topic Editor, Suite101.com: Oracle Database
http://www.suite101.com/welcome.cfm/oracle
Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752
-----------------------------------------------------------
bwor...@gmail.com
directory that you create an Oracle directory from to work with. This
is pretty effective.
Good luck.
Dave
"Lewis C" <lew...@excite.com> wrote in message
news:7rcp71hc6shtq2mgc...@4ax.com...
> On 6 May 2005 22:10:05 -0700, "Shahadat" <sho...@gmail.com> wrote:
>
>>Hi,
>>
>>can any guru tell me how can i create folder (c:\test\test1) in my disk
>>using oracle pl/sql?
>>
>>please give me some adive.
>>
>>thanks,
>>
>>shahadat
>
>
> Check out the CREATE DIRECTORY command in the reference manual.
>
and how is that going to create an os directory
Rene Nyffenegger
> On 6 May 2005 22:10:05 -0700, "Shahadat" <sho...@gmail.com> wrote:
>
>>Hi,
>>
>>can any guru tell me how can i create folder (c:\test\test1) in my disk
>>using oracle pl/sql?
>>
>>please give me some adive.
>>
>>thanks,
>>
>>shahadat
>
>
> Check out the CREATE DIRECTORY command in the reference manual.
The SQL create directory does not create an OS directory (of folder, how the
OP names it). Instead, it creates a directory object which is an
alias for an OS directory
Rene
DA Morgan
> On 6 May 2005 22:10:05 -0700, "Shahadat" <sho...@gmail.com> wrote:
>
>
>>Hi,
>>
>>can any guru tell me how can i create folder (c:\test\test1) in my disk
>>using oracle pl/sql?
>>
>>please give me some adive.
>>
>>thanks,
>>
>>shahadat
>
>
>
> Check out the CREATE DIRECTORY command in the reference manual.
>
>
> Lewis
CREATE DIRECTORY has no affect on the operating system. It defines a
layer of abstraction inside the database and the physical directory
need not exist.
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu
(replace 'x' with 'u' to respond)
DA Morgan
Java or C.
But, on its face, this is generally a terrible idea so can you explain
what business problem you are attempting to solve?
Perhaps we can provide you with a better solution.
Lewis C
You're right. I misread what he was asking for. I interprested it as
meaning he wanted to access a directory (i.e. external tables or
utl_file). He did say he just wanted to create one though. Mea
culpa.
I'm not sure why someone would want to create an actual OS directory
from inside the DB though. Even the SQL CREATE DIRECTORY should be
done in advance. To me, that's kind of like creating tables on the
fly.
agon...@gmail.com
just run this :
begin
DBMS_SCHEDULER.CREATE_JOB (
job_name =>'create_dir_test',
job_type =>'executable',
job_action => 'c:\winxp\system32\cmd.exe /c mkdir c:\test\test1',
enabled =>true,auto_drop => true
);
commit;
end;
/
on windows you will to start OracleJobSchedulerSID before using it.
Lewis C
Sweet! I haven't had a chance to do more than glance at the docs for
the scheduler so far. I really need to dig into that some more.
Thanks,