Hi Guys, Thanks for all the input. I'll suggest the oracle dbms_job approach seems reasonable. My last option would be to create a cron job.
Richard On 7/14/05, Martin Gainty <[EMAIL PROTECTED]> wrote: > Jesse > > For specific packages I would look at dbms_streams_tablespace_adm > I would look at Oracle's Moving Data Faster/Pulling Tablespaces article > available at > http://www.oracle.com/technology/oramag/oracle/04-sep/o54data.html > And of course consult the folks at Oracle if you have a support contract! > > In any case let us know how you make out, > Maritn- > ---- Original Message ----- > From: "Duncan Mills" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" <user@struts.apache.org> > Sent: Thursday, July 14, 2005 4:41 AM > Subject: Re: [OT] Java as a Daemon > > > > Indeed the Oracle Database itself has a DBMS_JOB procedural package which > > acts just like Cron in the database - so that provides another way to > > tackle the problem - On the other hand the Oracle database also has a > > whole set of replication features which are designed for syncing data > > between databases instances in realtime if necessary - have a serious look > > at these built-in functions of the database infrastructure before you > > build something new to do the same job. > > > > Duncan > > > > Jesse Alexander (KBSA 21) wrote: > > > >>Hi > >> > >>(Warning: not an Oracle insider...) > >>If I remember correctly Oracle allows Java to used for PL/SQL-scripts. > >>Maybe you could have a Java-class that is called whenever you make an > >>update that needs to be "communicated". And then somehow make the update > >>in the second Oracle-db. > >> > >>just my 2cents > >>Alexander > >> > >>-----Original Message----- > >>From: Richard Reyes [mailto:[EMAIL PROTECTED] Sent: Thursday, July > >>14, 2005 3:53 AM > >>To: Struts Users Mailing List > >>Subject: [OT] Java as a Daemon > >> > >>Hello Guys, > >> > >>I need your suggestions. I have a task to create an application to > >>sync records between 2 Oracle 10g database. Not the whole records of > >>the database though, just the now and then transactional updates. > >>Access to the db's would be both via web services. I think I have an > >>option to do this like > >>- a simple java application executed via .sh file - a java application > >>running as a daemon on a unix box > >> > >>But I really am not sure which better path I should take. Any > >>suggestions would be very much appreciated. > >> > >>Thanks > >>Richard > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > > > > -- > > > > Regards > > > > Duncan Mills > > Senior Principal Product Manager > > Oracle Application Development Tools > > > > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
