OraFAQ Forum: Server Utilities » How to check existence of path for creating directory

Home » RDBMS Server » Server Utilities » How to check existence of path for creating directory

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check existence of path for creating directory [message #172811]

Thu, 18 May 2006 02:54

agrawal_vaibhao
Messages: 20
Registered: May 2006

Junior Member

Hi,
I am creating directory in oracle with statement as follows
-- Create directory
create or replace directory DATA_DIR
as 'D:\OracleDirectory\DataDir';

Now is there any thing that tells me whether the path i am giving exists or not, so that i did not get invalid directory path error.

Thanks in advance.

Report message to a moderator

Re: How to check existence of path for creating directory [message #172832 is a reply to message #172811]

Thu, 18 May 2006 04:00

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

How about using dir or ls?

DOS:\>dir D:\OracleDirectory\DataDir
The system cannot find the file specified.

Report message to a moderator

Re: How to check existence of path for creating directory [message #172848 is a reply to message #172811]

Thu, 18 May 2006 05:59

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Oracle doesn't verify that the path exist, so as Frank indicated, you'll have to check the O/S first.

The directory doesn't have to exist in order to create a directory reference in Oracle.

Report message to a moderator

Previous Topic:	EXPORT
Next Topic:	Access to OBDC connectivity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 08:56:25 CDT 2024