Home » SQL & PL/SQL » SQL & PL/SQL » plsql
plsql [message #322537] Sat, 24 May 2008 04:36 Go to next message
amrlekid
Messages: 18
Registered: May 2008
Junior Member
Hello,

Oracle 9i on Win Xp.

I want to achieve the procedure BACKUP or my archivelog Database. But I don't know HOW TO CALL AN OS COMMAND ( copy for instance) FROM A PLSQL SCRIPT?

thanks for your help,
Re: plsql [message #322538 is a reply to message #322537] Sat, 24 May 2008 04:44 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Visit
http://www.orafaq.com/faq/how_does_one_put_a_database_into_archivelog_mode

Regards,

MSMallya
Re: plsql [message #322564 is a reply to message #322537] Sat, 24 May 2008 09:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@amrlekid

Great to call your topic "plsql" in "SQL & PLSQL" forum, we can then be sure you are in the correct forum.

But wait, you want to call an OS command from a script, in the end, may be this is not the correct forum.
Precise you question: from a script or from PL/SQL code?

Regards
Michel

[Updated on: Sat, 24 May 2008 09:03]

Report message to a moderator

Re: plsql [message #322651 is a reply to message #322564] Sun, 25 May 2008 15:42 Go to previous messageGo to next message
amrlekid
Messages: 18
Registered: May 2008
Junior Member
@michel

I want to call an OS command from a PLSQL code.

Precisely the plsql code aims to achieve the backup procedure of my database, but it's not finished yet simply because I do not know how to call an OS command (copy c:\source_path\file.dbf c:\dest_path\file.dbf) from this PLSQL code.

Re: plsql [message #322653 is a reply to message #322537] Sun, 25 May 2008 16:23 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
EXTERNAL PROCEDURE or Java
Re: plsql [message #322656 is a reply to message #322653] Sun, 25 May 2008 17:39 Go to previous messageGo to next message
amrlekid
Messages: 18
Registered: May 2008
Junior Member
.. hem hem ... So there's a hard work waiting for me then !!
Re: plsql [message #322678 is a reply to message #322537] Sun, 25 May 2008 22:05 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>So there's a hard work waiting for me then !!

While a shovel is a great tool for making a whole in the ground,
it is less than ideal for screwing in a screw, sawing a board, or driving in a nail.

You are using the wrong tool to implement backups.
In My Opinion, backups should be invoked from an Operating System script.
Re: plsql [message #322687 is a reply to message #322656] Sun, 25 May 2008 23:08 Go to previous message
Barbara Boehmer
Messages: 8633
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:952229840241

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:952229840241#30415721491190
Previous Topic: How to create user in Oracle ?
Next Topic: regarding performance of database
Goto Forum:
  


Current Time: Tue Dec 06 04:27:07 CST 2016

Total time taken to generate the page: 0.08595 seconds