OraFAQ Forum: SQL & PL/SQL » Regarding Batch Job to retrieve data from Client DB to our local DB

Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Batch Job to retrieve data from Client DB to our local DB (Oracle 9i, Windows-XP)

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

Regarding Batch Job to retrieve data from Client DB to our local DB [message #349115]

Thu, 18 September 2008 23:40

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://tahiti.oracle.com

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

joy_division
Messages: 4963
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

Report message to a moderator

Previous Topic:	Job Scheduling
Next Topic:	PL/SQL create text file from Oracle table data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 16:41:45 CST 2025