Creating directory objects in Oracle 11g with relative path

Question

I'm using JDBC to create a directory object in the database.

i.e create or replace directory "dir" as 'c:\temp';

My question is:

I want to pass the path at runtime
Or at least specify path relative to current one. I mean : create or replace "dir" as './../tempdir'

Is there a way to do this or is specifying absolute path the only way out.

Why do you want relative paths? Are you sure you know what they would be relative to? What do you mean by "current path"? Those are file paths on the database server, unaffected by where you run the client from. — Thilo
– Thilo, Commented Dec 27, 2011 at 7:31
I'm using Oracle capture and replay in my App.By relative path, I mean the generated capture files to be stored in a directory inside the App folder. By, current path I mean my .java file's path in which I'm writing the "create directory" statement — Ravi
– Ravi, Commented Dec 27, 2011 at 7:50
Oracle does not allow dynamic manipulation of DIRECTORY objects, for very sound reasons. Get the full skinny by reading my response to another SO thread: stackoverflow.com/questions/8147756/… — APC
– APC, Commented Dec 27, 2011 at 9:38

Florin Ghita · Accepted Answer · 2011-12-27 07:56:12Z

2

From Oracle Doc:

path_name Specify the full path name of the operating system directory of the server where the files are located.

I think this is because there is no such thing as "current directory". (You are in database, not in command line :) )

You can post a question with your problem and you'll get help from community.

answered Dec 27, 2011 at 7:56

Florin Ghita

17.7k6 gold badges60 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ludovic Kuty Over a year ago

Note that you could use a relative path, relative to the absolute path specified by the DIRECTORY. That's the case when you use a BFILE where the BFILE locator = DIRECTORY + relative path.

Florin Ghita Over a year ago

have you tried that? here says that should be Directory + filename

Collectives™ on Stack Overflow

Creating directory objects in Oracle 11g with relative path

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related