How is Oracle Lite so lite?

From: Tom Angioletti <tomangioletti_at_my-dejanews.com>
Date: Thu, 18 Feb 1999 13:17:47 GMT
Message-ID: <7ah3tm$78k$1@nnrp1.dejanews.com>

I've been using the Enterprise version of Oracle for several years now, and knowing how many system resources it can consume I've become interested in Oracle Lite. I've been thru the Oracle documentation and just can't seem to come up with the reason that Oracle Lite is so lite. Would anyone who has used Oracle lite please answer the following:

Does Oracle Lite support all the same SQL commands as the Enterprise edition? Nested selects? Joins? Unions?
How many DB connections can I create to an Oracle Lite DB?
Other versions of Oracle have several processes continuously running to provide the DB service. It appears that Lite runs no processes. Is that correct?
Where's the product spec sheet for Oracle Lite showing max DB size, max number of rows/table, etc?

Thanks in advance for any help you can provide,
-Tom A.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 18 1999 - 07:17:47 CST