Oracle 7

From Oracle FAQ

Oracle 7 is a version of the Oracle Database.

Also see Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g and Oracle 11g.

Contents 1 History and Support Status 2 Features introduced 2.1 Oracle 7.3 - February 1996 2.2 Oracle 7.2 - May 1995 2.3 Oracle 7.1 - May 1994 2.4 Oracle 7.0 - June 1992

History and Support Status

First release: June 1992 (7.0)

Desupport End Dates (7.3):

• Error Correction ended on: December 31, 2000
• Extended Assistance Support ended on: December 31, 2003

Last patch-sets: 7.3.2.3, 7.3.3.6 and 7.3.4.5

Features introduced

The following new features were introduced with Oracle 7:

Oracle 7.3 - February 1996

• Partitioned Views
• Bitmapped Indexes
• Asynchronous read ahead for table scans
• Standby Database
• Deferred transaction recovery on instance startup
• Updatable Join Views (with restrictions)
• SQL*DBA no longer shipped.
• Index rebuilds
• db_verify utility introduced
• Context Option
• Spatial Data Option
• Tablespaces changes - Coalesce, Temporary/ Permanent,
• Trigger compilation, debug
• Unlimited extents on STORAGE clause.
• Some init.ora parameters modifiable - TIMED_STATISTICS
• Hash Joins, Antijoins
• Histograms
• Dependencies
• Oracle Trace
• Advanced Replication Object Groups
• PL/SQL - UTL_FILE

Oracle 7.2 - May 1995

• Resizable, autoextend data files
• Shrink Rollback Segments manually
• Create table, index UNRECOVERABLE
• Subquery in FROM clause
• PL/SQL wrapper
• PL/SQL Cursor variables
• Checksums - DB_BLOCK_CHECKSUM, LOG_BLOCK_CHECKSUM
• Parallel Create Table As (CTAS)
• Job Queues - DBMS_JOB
• DBMS_SPACE package
• DBMS Application Info
• Sorting Improvements - SORT_DIRECT_WRITES

Oracle 7.1 - May 1994

• ANSI/ISO SQL92 Entry Level
• Oracle Advanced Replication - Symmetric Data replication
• Snapshot Refresh Groups
• Parallel Recovery
• Dynamic SQL - DBMS_SQL
• Parallel Query Options - query, index creation, data loading
• Server Manager introduced
• Read Only tablespaces

Oracle 7.0 - June 1992

• Database Integrity Constraints (primary keys, foreign keys, check constraints, default values)
• Stored procedures and functions, procedure packages
• Database Triggers
• View compilation
• User defined SQL functions
• Role based security
• Multiple Redo members - mirrored online redo log files
• Resource Limits - Profiles
• Much enhanced Auditing
• Enhanced Distributed database functionality: INSERTS, UPDATES, DELETES, 2PC
• Incomplete database recovery (e.g. SCN based recovery)
• Cost Based Optimizer
• TRUNCATE tables
• Datatype changes (i.e VARCHAR2, CHAR, VARCHAR)
• SQL*Net v2, MTS
• Checkpoint process (CKPT)
• Data replication - Snapshots

	Oracle Database
	Oracle 2 | Oracle 3 | Oracle 4 | Oracle 5 | Oracle 6 | Oracle 7 | Oracle 8 | Oracle 9i | Oracle 10g | Oracle 11g