Home » SQL & PL/SQL » SQL & PL/SQL » Create directory...
Create directory... [message #265171] Wed, 05 September 2007 10:37 Go to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
I would like to know the following (I havent tried and tested):-

1. I have created "create directory"
2. Granted permission...

Now, I want to access the directory on my local computer, the database server runs somewhere else....

All I want to know is:-

After the above steps 1 and 2, when i try to access a file within the above directory on my local computer will it work? or the directory and the file must exists only on the computer where the oracle server is running????
Re: Create directory... [message #265173 is a reply to message #265171] Wed, 05 September 2007 10:50 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
How you want to access the Directory?Explain what you want to do?
Re: Create directory... [message #265174 is a reply to message #265171] Wed, 05 September 2007 10:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Oracle only knows directories/files on instance server.

Regards
Michel

[Updated on: Wed, 05 September 2007 10:50]

Report message to a moderator

Re: Create directory... [message #265175 is a reply to message #265173] Wed, 05 September 2007 10:54 Go to previous messageGo to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
DreamzZ

this is what I want, which I have mentioned on the original post

----------
Now, I want to access the directory on my local computer, the database server runs somewhere else....
----------
Re: Create directory... [message #265176 is a reply to message #265174] Wed, 05 September 2007 10:57 Go to previous messageGo to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
Michel

As usual got the answer from you.... Cheers...

So, effectively I cant access directory within my computer, and can access the directory within the oracle server...

Correct me if I am wrong....
Re: Create directory... [message #265177 is a reply to message #265176] Wed, 05 September 2007 11:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes this is correct.
You have workaround to mount the remote file system on server one but in many cases it is not supported (like cross-platform mount, for example Samba) or even does not work.

Regards
Michel

[Updated on: Wed, 05 September 2007 11:09]

Report message to a moderator

Re: Create directory... [message #265179 is a reply to message #265177] Wed, 05 September 2007 11:21 Go to previous messageGo to next message
sarans
Messages: 30
Registered: November 2006
Location: UK
Member
Michel

Excellent, thank you very much for your reply....

Cheers,
Saran.
Re: Create directory... [message #265256 is a reply to message #265171] Wed, 05 September 2007 22:46 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Create directory name ...

Here name is logical and known to oracle. It has no existence in OS. Also if you use,

create directory name as '/backup/test';

oracle will not create test folder although it is not exist in OS.
Create directory command is nothing but give a name(oracle knows this name) to an existing directory of Operating System.

Previous Topic: Droping subpartitions of a partition
Next Topic: Tracle PL/SQL code
Goto Forum:
  


Current Time: Thu Feb 06 23:47:59 CST 2025