How compatible is Oracle Lite with the standard Oracle Server?

Submitted by admin on Wed, 2005-11-09 23:40.

Although code compatibility is very high, the following features are not supported in Oracle Light:

PL/SQL (use Java Stored Procedures and triggers instead)
Oracle Light is intended as a small, single-user client database and do not support any server functionalities like Java CORBA ORB's, SQL*Net Listeners, etc.
In Oracle Lite, all rows are stored as objects, and there is a relational layer on top of the object layer to allow relational views of the data.
Oracle7/8 stores data in a relational format, then uses an object
metalayer to provide object views and functionality.
Only selected dictionary views are available, eg. ALL_TABLES, ALL_VIEWS, ALL_USERS, CAT, etc.
An Oracle Lite database can only be queried from a remote client if it's data is replicated.