Re: Oracle 8i and Oracle 9i Lite Sync

Mark Bole <makbo_at_pacbell.net> wrote in message news:<wvPXc.13110$DE1.10060_at_newssvr29.news.prodigy.com>...
> Frank van Bortel wrote:
>
> > Mark Bole wrote:
> >
> >> Sybrand Bakker wrote:
> >>
> >>> On 25 Aug 2004 23:42:23 -0700, karthi_at_myrealbox.com (Karthik) wrote:
> >>>
> >>>
> >>>> Is it possible to do a synchronisation between oracle 8i server and
> >>>> oracle 9i Lite,
> [...]
> >>
> > Sorry to barge in here, but did you ever take a look
> > at Oracle Lite? It has specifically been built to
> > be used in small computers (cell phones, PDA's) that
> > require synchronization.
> > Pretty easy to set up, and it works between 5.0.1 (aka 9i)
> > and 8.0 as well as 8i (according to
> > http://download.oracle.com/docs/pdf/A95260_01.pdf).
> >
> > So why don't you give it a try?
> >
>
> Your barging is welcome. I, for one, was completely ignorant of what
> Oracle Lite consisted of, and now that I've skimmed the link you
> provided, I'm pretty sure I mis-interpreted the OP.
>
> It sounds like a question for "Certify and Availability" in Metalink...?
>
> --Mark Bole

Thanks a lot for the reply. Now that i know that exact requirements, i would like to get an opinion abt this solution

there is an existing java web application that is running on field reps' laptops [on tomcat]. Currently an java database [hsql] is used as DB. there is a severe bottle neck with the existing system in terms of performance. so they want to upgrade to Oracle lite.. why Lite.. bcoz few years down the line, they want to use PDA, cell phones.. so do not want to double work. They also do a daily sync with the central oracle server [9i] using the java app .This reads data from the existing db and "inserts" it onto the oracle central server. once again this is also a time consuming proc. these "idle" times of reps has to be "minimised". Rewriting the java app with something else is not a solution. that is ruled out.

so,
1. a logic to do sync between oracle lite and oracle db 2. normal usage of db in a typical 3 tier web system

Any ideas . do reply

Karthik Received on Sun Aug 29 2004 - 23:40:21 CDT