Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Batch updates

Re: Batch updates

From: <John.Dailey_at_ing-fsi-na.com>
Date: Mon, 09 Jul 2001 06:08:48 -0700
Message-ID: <F001.003443B8.20010709060045@fatcity.com>

Sean, perhaps I am missing something from your question, but this sounds like a job for Oracle Lite (whatever name the marketing folks call it now, it used to be Oracle Lite anyway). I had an environment similar to your scenario.... engineers in the field would use their laptops all day scanning assets, etc. and then upload at night. They had a custom application on their machine and it used the Oracle Lite platform with a small database. This db was then synched over dialup each night with the enterprise DB, then in the morning they dialed up and got the work orders for the day. There were PL/SQL packages to check for integrity, etc. Obviously, the next logical extension to this project could have been using the Oracle Lite DB for Palms. In any case, look at the Oracle Lite product for this functionality... it may be just what you need.

BTW, if you get a chance and have the time (hard to get I know), load the Oracle Lite DB for Palms and play around w/ it.... it is really a neat tool. It even has a little SQL interface to write queries on. Don't know how well it scales but it is fun to mess around with.

HTH John D.

                                                                                       
                            
                    "Thater,                                                           
                            
                    William"             To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    <ThaterW_at_tele        cc:                                           
                            
                    rgy.net>             Subject:     Re: Batch updates                
                            
                    Sent by:                                                           
                            
                    root_at_fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    07/06/2001                                                         
                            
                    12:06 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L                                                           
                            
                                                                                       
                            
                                                                                       
                            




"O'Neill, Sean" wrote:

>

> 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?

replication to/from personal ORACLE? can you even do that? some 3rd party software i've had experience with used sqlbase [i think] to move stuff to/from a users laptop. [vantive for one.]

--
Bill "Shrek" Thater   Certifiable ORACLE DBA
Telergy, Inc.            thaterw_at_telergy.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
one ping to rule them all, one ping to find them, one ping to bring them
all, and in the darkness bind them.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
  INET: ThaterW_at_telergy.net

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: 
  INET: John.Dailey_at_ing-fsi-na.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).
Received on Mon Jul 09 2001 - 08:08:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US