Good Afternoon Richard
Agreed - a cron oracle dbms_job task would definitely fit the bill
10g is promoting their new Scheduler program which replaced dbms_job
task..take a look at
http://www.databasejournal.com/features/oracle/article.php/3413371
Sidebar :
You could also look at Ant which has also added the ability to run SQL
scripts take a look at
http://ant.apache.org/manual/
In any case Let me know how you make out,
Martin-
----- Original Message -----
From: "Richard Reyes" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <user@struts.apache.org>
Sent: Thursday, July 14, 2005 10:00 PM
Subject: Re: [OT] Java as a Daemon
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
