Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing connection to stored procedure
On Mar 30, 2:20 pm, "aadil" <aadi..._at_gmail.com> wrote:
> Hi all,
>
> I am doing the database purging. In which i have two different
> database servers one used as Main database server and other as history
> database server. My stored procedures are on the main server. Right
> now iam doing purging using DBLINK concept. Is there any other way to
> do it.
> Like passing connections directly to stored procedures or using Java
> stored procedures.
>
> Thanks,
Why don't you use dbms_job in each database? Doing so your client is freed, and you are available for other, more useful tasks.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Mar 30 2007 - 07:34:49 CDT