Home » RDBMS Server » Backup & Recovery » Export With DBMS_JOB
Export With DBMS_JOB [message #272263] Thu, 04 October 2007 06:14 Go to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Can I run "export database" with DBMS_JOB.
Re: Export With DBMS_JOB [message #272268 is a reply to message #272263] Thu, 04 October 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

Regards
Michel
Re: Export With DBMS_JOB [message #272492 is a reply to message #272268] Fri, 05 October 2007 04:39 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Oracle 9i Rel 2 (9.2.0.4.0 on Linux).....
exp is an OS command but in the WHAT filed of DBMS_JOB.SUBMIT() we can execute Database specific codes.....
So I m asking if someone have an idea about that....

Re: Export With DBMS_JOB [message #272494 is a reply to message #272492] Fri, 05 October 2007 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can create a Java procedure to execute an OS program, wrap it in a PL/SQL procedure that you can submit with dbms_job.

Regards
Michel
Re: Export With DBMS_JOB [message #272495 is a reply to message #272494] Fri, 05 October 2007 04:50 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
But I not used to JAVA I only know about PL/SQL and SQL.
If u have written java code for this as u advice then pls post here.........
Re: Export With DBMS_JOB [message #272496 is a reply to message #272495] Fri, 05 October 2007 04:53 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search on AskTom for "execute an OS command in PL/SQL"

Regards
Michel
Previous Topic: ora-01031
Next Topic: Flashback Not Enabled
Goto Forum:
  


Current Time: Mon Nov 04 06:20:34 CST 2024