Re: Oracle 9i Standard vs Enterprise

Standard and Enterprise versions use the same db engine. Main differences are:
price (300$ - 1 Std Named User, 800$ - 1 Ent Named User) OPS,
transportable tablespaces,
materialized views,
Fine-grained access control,
N-tier authentication/ authorization (with LDAP), ... In fact, instead-of triggers are available in standard version. Generally you can use standard edition with middle-size database (up to about 200 users)

details in Oracle metalink 112591.1 note and in server documentation.

---
Bartosz Bakunowicz
OCP DBA
bartekb_at_um.bialystok.pl

"Donovan R." <mdonovan_at_hotmail.com>wrote:



> OPS (Oracle Paralel Server), INSTEAD OF triggers also, you can not set

> up Designer Repository without this kind of triggers

> On Mon, 15 Apr 2002 16:43:15 -0400, "Christian Farley"

> <christian.farley_at_domtar.com> wrote:

>

> >Can someone tell me the major diffrence between Oracle 9i Standard

 edition


> >and enterprise edition ?

> >

> >

> >Thanks

> >

> >

>