Home » RDBMS Server » Security » Is it possible to create a new directory on linux fs from oracle (11g, redhat)
Is it possible to create a new directory on linux fs from oracle [message #484327] Mon, 29 November 2010 12:32 Go to next message
bugmage
Messages: 13
Registered: September 2010
Junior Member
I understand how to create a database directory object to point to a directory on the server File System. Is there a way to take the next step and create a new directory on the host file system from within Oracle?

Thanks,

-Andrew
Re: Is it possible to create a new directory on linux fs from oracle [message #484330 is a reply to message #484327] Mon, 29 November 2010 12:40 Go to previous messageGo to next message
BlackSwan
Messages: 22802
Registered: January 2009
Senior Member
>Is there a way to take the next step and create a new directory on the host file system from within Oracle?
No, do OS operations from the OS command line

I could kind of be done via Java or External Procedure,
but both operate at OS level.

[Updated on: Mon, 29 November 2010 12:41]

Report message to a moderator

Re: Is it possible to create a new directory on linux fs from oracle [message #484331 is a reply to message #484327] Mon, 29 November 2010 12:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can call OS commands/Shell scripts from Oracle using pl/sql and Java. Several options available.
One such
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:16212348050#39092679158568
Re: Is it possible to create a new directory on linux fs from oracle [message #484337 is a reply to message #484331] Mon, 29 November 2010 13:14 Go to previous messageGo to next message
bugmage
Messages: 13
Registered: September 2010
Junior Member
So I could create a job to run a script that already exists on the file system. Could I then write a sh file to \tmp, then run it via a job?

That would allow me to do everything via a SP, kind of a hack
Re: Is it possible to create a new directory on linux fs from oracle [message #484338 is a reply to message #484337] Mon, 29 November 2010 13:15 Go to previous messageGo to next message
BlackSwan
Messages: 22802
Registered: January 2009
Senior Member
>Could I then write a sh file to \tmp, then run it via a job?
SCHEDULER jobs can invoke OS script
Re: Is it possible to create a new directory on linux fs from oracle [message #484341 is a reply to message #484337] Mon, 29 November 2010 14:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59182
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
bugmage wrote on Mon, 29 November 2010 20:14
So I could create a job to run a script that already exists on the file system. Could I then write a sh file to \tmp, then run it via a job?

That would allow me to do everything via a SP, kind of a hack

Only if your (bad) DBA allows you to do so.

Regards
Michel

Re: Is it possible to create a new directory on linux fs from oracle [message #484343 is a reply to message #484341] Mon, 29 November 2010 15:06 Go to previous messageGo to next message
bugmage
Messages: 13
Registered: September 2010
Junior Member
Quote:

Only if your (bad) DBA allows you to do so.

Regards
Michel


Yeeep

I't surprises me that there's not a easier way, although I agree the developer should not have access outside oracle.

Thanks for the help guys/gals Smile

[Updated on: Mon, 29 November 2010 15:12]

Report message to a moderator

Re: Is it possible to create a new directory on linux fs from oracle [message #484366 is a reply to message #484343] Tue, 30 November 2010 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59182
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I't surprises me that there's not a easier way

Why? Oracle is data manager not a file manager.
Do you ask your OS to create a table in the database?

Regards
Michel
Re: Is it possible to create a new directory on linux fs from oracle [message #484507 is a reply to message #484366] Wed, 01 December 2010 03:20 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
"Do you ask your OS to create a table in the database?"
Definitely his next requirement will be..!

sriram
Previous Topic: Login as sysdba
Next Topic: Oracle Advanced Security
Goto Forum:
  


Current Time: Tue Sep 23 05:35:07 CDT 2014

Total time taken to generate the page: 0.10079 seconds