Oracle8 New Features/ Upgrade FAQ
$Date: 01-Jun-1997 $
$Revision: 1.0a $
$Author: Frank Naudé $
|
Great 8: The database for network computing
|
Topics
Back to top of file
How does one upgrade to Oracle8?
If you are running Oracle 7.1, 7.2 or 7.3, you can use the
Oracle8 Migration Utility to upgrade the data dictionary.
The amount of time it takes to do the migration depends on
the number of tables you have in the database, and not on the
size of the database. Note that you cannot perform a migration
after a patch set has been installed. Migrate first; then apply
the necessary patch sets.
For versions prior to Oracle 7.1, export your data and import
it into a newly created Oracle8 database.
For more information, refer to the "Oracle8 Server Migration Release 8.0" manual.
Back to top of file
Can one exp from Oracle8 and imp into Oracle7?
Run catexp.sql and catexp7.sql from Server Manager on your Oracle8 database.
Both these files can be found in the $ORACLE_HOME/rdbms/admin directory.
You can now run the Oracle7 exp utility against your Oracle8 database and import
the resulting dump file back into an Oracle7 database.
Back to top of file
How does one create partitioned tables?
Oracle8's partitioning scheme will give DBAs the ability to perform
maintenance on partitions without having to bring down an entire table
(import/ export/ load/ etc).
The SQL optimizer will bypass partitions that don't contain data
pertinent to the query being solved.
Look at the following example:
CREATE TABLE emp
( id NUMBER(5) PRIMARY KEY,
name VARCHAR2(50) NOT NULL,
address VARCHAR2(50),
phone VARCHAR2(15),
email VARCHAR2(100) )
PARTITION BY RANGE ( name )
( PARTITION p1 VALUES LESS THAN ('L') TABLESPACE ts1,
PARTITION p2 VALUES LESS THAN (MAXVALUE) TABLESPACE ts2 )
Notes:
Oracle8 sorts nulls greater than all other values except MAXVALUE.
Back to top of file
How does one create an object?
CREATE TYPE employee_type as OBJECT (
name varchar2(30),
ssn varchar2(11),
salary number),
MEMBER FUNCTION get_id RETURN number);
CREATE TYPE BODY emp_type (
MAP MEMBER FUNCTION get_id RETURN number is
BEGIN
RETURN ascii_to_num(ssn);
END;);
CREATE TABLE emp OF employee_type;
Back to top of file
