OraFAQ Forum: Server Administration » In a nutshell, what are the main differences between Oracle 7.3 and 8i?

Home » RDBMS Server » Server Administration » In a nutshell, what are the main differences between Oracle 7.3 and 8i?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

In a nutshell, what are the main differences between Oracle 7.3 and 8i? [message #54163]

Fri, 01 November 2002 03:47

Julie Leggs
Messages: 1
Registered: November 2002

Junior Member

I'm really looking forward to the answer of this question, it's been bugging me for weeks. *giggle*

Thanks for any answers in advance, I'll owe you one.

Report message to a moderator

Re: In a nutshell, what are the main differences between Oracle 7.3 and 8i? [message #54180 is a reply to message #54163]

Fri, 01 November 2002 11:42

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hi basically oracle 7.3 is an RDBMS ...(What is RDBMS? :)) Look at the Codd's Rules) .. Coming to 8 its called as ORDBMS i.e. Objectt Orient RDBMS...u have the features like Object technology etc and 8i as it sounds Internet Capability...built in Support with Java and hence Internet Capability.. and yeah u can call 8i as WORDBMS....

is that ok ?
sai

Report message to a moderator

Re: In a nutshell, what are the main differences between Oracle 7.3 and 8i? [message #54190 is a reply to message #54163]

Mon, 04 November 2002 05:19

N
Messages: 26
Registered: April 2002

Junior Member

<font color=#990000>
Transportable tablespaces
Locally-managed tablespaces
Locally-managed temporary tablespaces
Dropping Columns
Temporary Tables
Resource Manager
New Features of SQL*Loader
RMAN
    Hot backups without ALTER TABLESPACE xxx BEGIN/END BACKUP
    Incremental Backups
    Detection of corrupted database blocks
Improvements to Redo Log Archiving
New Log Miner functionality
Bounded recovery times

Detect and handle database block corruption using DBMS_REPAIR

Materialized Views

Cost based optimizer - query rewrite

Rollup, Cube, and Grouping

Hash Partitioning
Composite Partitioning
Partition-wise joins
Partition management operations
Partitioning with LOBs, IOTs, and objects
Parallel Execution
    parallel SPLIT PARTITION
    parallel MERGE PARTITION
    parallel ALTER TABLE � MOVE
    parallel ALTER INDEX � REBUILD
    parallel ANALYZE (with    DBMS_STATS)
    PARALLEL_AUTOMATIC_TUNING = TRUE
Standby Database - ALTER DATABASE OPEN READ ONLY
Memory Management Enhancements
    Large Pool
    Segmented Buffer Cache Pools
<font color=#000000>

Report message to a moderator

Previous Topic:	Seed Data
Next Topic:	How to drop and rebuild the JVM in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 15:46:59 CST 2024