Re: Batch updates

We briefly thought of using Oracle Lite. It uses a subset of replication and advanced queueing to do its magic. It looked like it might have worked.

But, as we wanted to sell a product, Oracle Lite licensing added like 300 bucks a seat to the product, so the boss decided not to go with it.

Of course, 6 months later, that department is now dead, there is NO product, including no product that would have cost an extra 300 bucks.

Yosi

Guy Hammond wrote:

> Does Oracle Lite do this? I remember attending a seminar where Oracle
> were talking about running Lite on PDAs to support sales force
> automation. They could take orders and check inventory on their PDAs,
> query contacts and itineraries, etc, then it would replicate to real
> Oracle in one batch when they connected to dial-up every day. There was
> a mechanism for reconciling conflicts, for example if you had 100 units
> in stock, salesman A sold 50 and B sold 60, maybe customer A would get
> 45 units and B 55 until new inventory was ready. That sort of thing.
>
> g
>
> -----Original Message-----
> Sent: Friday, July 06, 2001 4:41 PM
> To: Multiple recipients of list ORACLE-L
>
> I'd appreciate hearing from folk what "solutions" there are for the
> following scenario. Users with laptops want to be able to input data
> whilst
> not connected to database for subsequent upload to database. Apart from
> developing PL/SQL code to realise this functionality with associated
> integrity checks etc. are there other possible (3rd party) solutions?
>
> If database was small enough there has been some notion of copying
> database
> to laptop and subsequently re-synchronising when connecting to central
> database. Are there solutions out there for this?
>
> I've a sneaking suspicion the solution to this is hidden in the caverns
> of
> my memory but it ain't coming out!
>
> Thanx in advance for anyone who takes time to reply :)
>
> Sean :)
>
> Rookie Data Base Administrator
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "Nobody loves me but my mother... and she could be jivin' too." - BB
> King
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Guy Hammond
> INET: guy.hammond_at_avt.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).

--
Thanks,

Yosi


---------------------------------------------------------
Yosi Greenfield
Oracle Certified DBA
ygreenfield_at_compuserve.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).