Re: Oracle Lite VS Personal Oracle

From: Jim Swanson <jswanson_at_nz.oracle.com>
Date: Sat, 03 Oct 1998 06:15:56 +1000
Message-ID: <3615347C.BB2B9E09@nz.oracle.com>

> Personal Oracle Lite reminds me of a flat file database, like dbase.
> It's a bit more capable than dbase. You can create tables, but not
> triggers or stored procedures, etc.
>
> POLite is just that. It takes up a lot less memory and disk space,
> but forgoing the robustness of a RDBMS server.

Just to set the record straight here ... Oracle Lite is nothing like a flat file database -- it's a real RDBMS that just happens to have a miniscule footprint (350k plus 20k - 400k depending on whether your apps talk JDBC or OCI) yet it has all the features of Oracle8 (ones that are sensible in a tiny mobile database, that is) like replication, row-level locking, support for BLOBs, objects and the like.

You can talk to it using SQL*Plus like any Oracle RDBMS. As Joe correctly pointed out, it doesn't do PL/SQL stored procedures, but because it's written in Java , you can store persistent Java objects in it. It doesn't need a DBA to install and run it .... it lives in a single file and manitains itself.

It's aimed more at the (palmtop) mobile environment than at desktops, but you can use it anywhere you'd use something like Access (it's often used under Access-developed desktop apps as an upgrade for the Jet database engine).

Jim Swanson
Business Solutions Consultant

.....................................................................
Oracle
New Zealand Limited               Phone:  +64.9.309 1946
Lumley House                      DDI  :  +64.9.359 3317
7 City Road                       Fax  :  +64.9.377 8847
Auckland, New Zealand             Email:  jswanson_at_nz.oracle.com
.....................................................................
              Visit Oracle at http://www.oracle.com

.....................................................................

The opinions expressed in this message are my own, and are not necessarily those of Oracle Corporation Received on Fri Oct 02 1998 - 15:15:56 CDT