OraFAQ Forum: Server Utilities » Scheduling an export

Home » RDBMS Server » Server Utilities » Scheduling an export

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

Scheduling an export [message #232950]

Tue, 24 April 2007 04:24

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi All,

Can I run EXPORT utility from within a stored procedure? If it is possible, can you please illustrate with an example.
The intention is to run this procedure periodically.

I am using Oracle 9.2.0.6

Please help!!

Thanks
qA

[Updated on: Tue, 24 April 2007 04:34]

Report message to a moderator

Re: Scheduling an export [message #232955 is a reply to message #232950]

Tue, 24 April 2007 04:33

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no API for export as there is one for Data Pump but you can execute an OS command from PL/SQL.
Have a look at thread "Java procedure for host calls on Unix environment" on AskTom.

Regards
Michel

Report message to a moderator

Re: Scheduling an export [message #232970 is a reply to message #232955]

Tue, 24 April 2007 05:31

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Thanks Michael. Any clue if EXPORT can be run from a normal PL/SQL Block instead of Java Procedures?

Report message to a moderator

Re: Scheduling an export [message #232972 is a reply to message #232970]

Tue, 24 April 2007 05:44

kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA

Junior Member

Hi,
How about making a script and schedule it in OS scheduler?

Report message to a moderator

Re: Scheduling an export [message #232975 is a reply to message #232970]

Tue, 24 April 2007 06:06

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Wrap the Java procedure inside a PL/SQL procedure.
Read the article this is how it is used.

Regards
Michel

Report message to a moderator

Previous Topic:	IMP-00017: following statement failed with ORACLE error 942:
Next Topic:	Calling SQLLDR using crontab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 12:26:39 CST 2024