Re: Enterprise vs Server Oracle8 on NT?

From: Thiru <tmgn_at_excite.com>
Date: Thu, 23 Sep 1999 13:21:37 -0400
Message-ID: <37EA61A0.4DC6B81C@excite.com>

These are the features supported in Oracle EE but not in WGs ;

1.Parallel Query
2.Advanced Replication
3.Advanced Queuing
4.Connection Manager
5.Parallel Backup/recovery
6.Incremental Backup
7.Point-in-time tablespace Recovery
8.Multiprotocol Connectivity
9.Online Index rebuild
10.Bitmap Indexes
11.Diagnostics,Tuning and Change Management packs
12.Partitioning option
13.Automated Standby option
14.Parallel Server option
15.Jserver EE option

16.Advanced Security option
17.Spatial data,Time series,Visual Info Retrieval Catridges..

Incremental Backup/Recovery are supported by Recovery Manager .This feature enables backing up Datafiles that contains only those blocks that got modified since the last backup..

Point in time Tablespace REcovery allows Recovering Tablespace upto a Specific tme by rolling forward the Archived Redo log files onto the Datafiles..

All Datafile Headers,Control files and redo log files store System change nos(SCN) that behave like a Timestamp that helps in Transaction Mgmt & Recovery..

Hope this helps.

-Thiru

Yev wrote:

> What are the major differences between Oracle 8 Workgroup Server and
> Enterprise Edition?
>
> I got the following from Oracle8/WINNT Black Book:
> (Items missing from Workgroup Server):
>
> 1. Incremental Backup & Recovery:
> What Oracle tool does this refer to? Is the tool missing, or is the option
> missing from the tool?
>
> 2. Point in time tablespace Recovery
> Does this mean that you can only recover using the whole redo log file
> instead of a just part of it? Does Enterprise add a timestamp to the redo
> logs??
>
> TIA
>
> Yev
Received on Thu Sep 23 1999 - 12:21:37 CDT