Create Directory

[gandhi]

Hi Friends,

Oracle has given DIRECTORY facilities to mention OS directories. This will depreciate utl_file_dir parameter. In the same way, Is it possible to create a directory for mulitple OS directories.

eg.
SQL> CREATE DIRECTORY demo AS 'c:\demo,d:\demo\test';


Thanks
gandhi

[davey23uk]

do you mean like this?

SQL> create directory tmp as '/tmp';

Directory created.

create directory tmp2 as '/var/tmp/'

Directory created.

SQL>

[gandhi]

Yes,

But, i want to create one directory in Oracle by referring multiple OS directories.


Thanks
gandhi

[davey23uk]

ah I think u mean create directory tmp as '/tmp', '/var/tmp' or something like that.

i do not think it is possible