OraFAQ Forum: Security » Is it possible to create a new directory on linux fs from oracle

Home » RDBMS Server » Security » Is it possible to create a new directory on linux fs from oracle (11g, redhat)

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

Is it possible to create a new directory on linux fs from oracle [message #484327]

Mon, 29 November 2010 12:32

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Mahesh Rajendran
Messages: 10706
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

Report message to a moderator

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Could I then write a sh file to \tmp, then run it via a job?
SCHEDULER jobs can invoke OS script

Report message to a moderator

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

Michel Cadot
Messages: 68417
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

Report message to a moderator

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

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

Michel Cadot
Messages: 68417
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

Report message to a moderator

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

ramoradba
Messages: 2456
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

Report message to a moderator

Previous Topic:	Login as sysdba
Next Topic:	Oracle Advanced Security

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 09:02:01 CDT 2023