OraFAQ Forum: Backup & Recovery » Export With DBMS

Home » RDBMS Server » Backup & Recovery » Export With DBMS_JOB

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

Export With DBMS_JOB [message #272263]

Thu, 04 October 2007 06:14

smunir362
Messages: 310
Registered: September 2007

Senior Member

Can I run "export database" with DBMS_JOB.

Report message to a moderator

Re: Export With DBMS_JOB [message #272268 is a reply to message #272263]

Thu, 04 October 2007 06:24

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle version?

Regards
Michel

Report message to a moderator

Re: Export With DBMS_JOB [message #272492 is a reply to message #272268]

Fri, 05 October 2007 04:39

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....

Report message to a moderator

Re: Export With DBMS_JOB [message #272494 is a reply to message #272492]

Fri, 05 October 2007 04:42

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

Report message to a moderator

Re: Export With DBMS_JOB [message #272495 is a reply to message #272494]

Fri, 05 October 2007 04:50

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.........

Report message to a moderator

Re: Export With DBMS_JOB [message #272496 is a reply to message #272495]

Fri, 05 October 2007 04:53

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Search on AskTom for "execute an OS command in PL/SQL"

Regards
Michel

Report message to a moderator

Previous Topic:	ora-01031
Next Topic:	Flashback Not Enabled

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 15:06:27 CDT 2024