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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
