Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Batch Job to retrieve data from Client DB to our local DB (Oracle 9i, Windows-XP)
icon1.gif  Regarding Batch Job to retrieve data from Client DB to our local DB [message #349115] Thu, 18 September 2008 23:40 Go to next message
Rammi
Messages: 3
Registered: September 2007
Location: Inida
Junior Member
Hi Folks,

GoodDay, Previously I worked as a Oracle Developer and recently shifted into a BIG organisation as PL?SQL developer. Here my base work is with INTERFACES(Stored Procedure). That is retrieving data from client DB and need to put the data in our staging tables. For that i created 2 INTERFACES(stored procedures). One is for one time migration. No need to run on regular basis. The second one is to run regularly why because if any updations are done in client DB that should be replicate to our DB. For that we need to run a BATCH JOB regulary 24X7 basis.

But i dont have any working knowledge on BATCH JOB creation and running. Please let me guide on this issue ASAP.

Regards,
Ramesh.
Re: Regarding Batch Job to retrieve data from Client DB to our local DB [message #349117 is a reply to message #349115] Thu, 18 September 2008 23:43 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://tahiti.oracle.com
Re: Regarding Batch Job to retrieve data from Client DB to our local DB [message #349120 is a reply to message #349115] Thu, 18 September 2008 23:49 Go to previous messageGo to next message
navneet_sharma
Messages: 70
Registered: September 2008
Location: New Delhi, India
Member
read dbms_job package.it has various procedures for diffrent tasks like job scheduling,submitting,killing,breaking etc.
Re: Regarding Batch Job to retrieve data from Client DB to our local DB [message #349154 is a reply to message #349120] Fri, 19 September 2008 02:20 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm curious as the the difference between an Oracle developer and a Pl/Sql developer.......
Re: Regarding Batch Job to retrieve data from Client DB to our local DB [message #349276 is a reply to message #349154] Fri, 19 September 2008 10:46 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Oracle Developer (now called Oracle Developer Suite) is an Oracle Corporation product for working with Forms and Reports, and PL/SQL Developer is a third party product for working with stored procedures Wink
Previous Topic: Job Scheduling
Next Topic: PL/SQL create text file from Oracle table data
Goto Forum:
  


Current Time: Fri Dec 09 21:06:36 CST 2016

Total time taken to generate the page: 0.10436 seconds