Re; Different Oracle Versions

Nicolas Bronke wrote

Can anybody explain me what the specific differences are between

• Oracle Enterprise Server (or Oracle Server)
• Oracle Workgroupserver
• Personal Oracle
• Oracle Lite

Enterprise server is the full featured, more options included top 'o the line database server. Higher priced, but most options are included.. Suited for large/very large apps/large user counts, etc. Available for lots of platforms/OSs.

Workgroup server - not as many options, more reasonably priced. Use for small/medium and not to large projects, with fewer concurrent users etc. (this is still a full featured sever database with high reliability). Available for lots of platforms/OSs.

Personal oracle runs on PCs (win95/win98/nt). Suitable for single user at a time. Full implementation of most Oracle SQL (procedures, table triggers and all). Useable for single work station development of projects. Probably more than a single user need for home use (possibly MS access would be better).

It is relatively easy to migrate an application to a larger oracle platform, from PO to WGO to EO. All three support most oracle tools.

Oracle lite is a different story. It is a small foot print (1 meg?) simple database engine. It uses simplified table structures and SQL query and DML commands but is it is NOT really related to the other databases (no plsql in PO). It is usable for embedded applications with a power objects, or Visual Basic front end.

It is always difficulte to know exactly what oracle is providing by product name, and it get worse every year with new and renamed products.

You might try oracle's web pages for more info.

HTH Received on Sat Feb 27 1999 - 00:27:33 CST