Oracle-L: RE: Daily job to populate table in another database

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Tue, 10 Dec 2002 17:04:11 -0800
Message-ID: <F001.0051719F.20021210170411@fatcity.com>

Hi Hemant,

Thanks for the tips.

Does anyone know whether SNP process .ie. DBMS_JOB will degrade the database performance ? Please advise. Thanks.

Regds,
New Bee

This communication (including any attachment) is meant only for the recipient(s) named above and may contain confidential or legally privileged information. If you are not an intended recipient, this communication has been sent to you in error and you must delete all copies of this communication from your computer system and notify the sender immediately by reply email. Unauthorised use, disclosure, dissemination, distribution, retention, copying or reliance on this communication is prohibited and may attract civil and/or criminal penalties. Thank you.

		-----Original Message-----
		From:	Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
		Sent:	Tuesday, December 10, 2002 11:04 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Re: Daily job to populate table in another

database

See Note #1068369.6 on MetaLink.

		Hemant
		At 01:28 AM 10-12-02 -0800, you wrote:


		>Hi Gurus,

		>

		>If you need to copy data (after some manipulations) from

database A to


		>another table in database B, how do you achieve that ?

		>Our current practice is to use crontab (schedule daily job)

and sqlplus


		>(procedure to copy the data over to another database via

dblink).


		>

		>Do you think it's more efficient to use DBMS_JOB ? Can

DBMS_JOB call the


		>procedure at the same time daily ? Any sample? Please

advise. Thanks.


		>

		>Regds,

		>new bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Dec 10 2002 - 19:04:11 CST