Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: being pecked to death by ducks

RE: being pecked to death by ducks

From: Durinda.Jones <>
Date: Mon, 11 Dec 2000 14:48:16 -0600
Message-Id: <>


One thing I remember is if you use a parfile, you need to make it USERID=USER/PASS, it doesn't rely on placement anymore.

I found this on Metalinks. Not much, but it should help:

From: Oracle, Rajesh Varadhan 17-Aug-00 09:48 Subject: Re : Migration of 7.3.4 database to 8.1.6 on HP-9000(v.11)

Hi Aftab,
In case of export then you need to be careful of the new rowid format.The existing rowids will not be changed until they are accessed. You will want to take care of this all at once rather than wait for your users to access the rowids in the tables. One way is to perform full table scans of the entire database (except for sys owned objects) is to do a full export to null, so that no export file is generated.
-> exp system/manager full=y file=/dev/null
* Also, if you have stored rowids in your tables for use by your applications, you need to convert these to the Oracle8 format with the dbms_rowid package. If you have plenty of time at your disposal, you may go in for this method.Reorganisation is possible.

In case of migration utility, you need to have sufficient amount of space in the system tablespace.This method is faster. Reorganisation is not possible.

Please refer to the Doc ID NOTE:76460.1 in metalink also.

Hope this gets you down the road.

Durinda Jones

-----Original Message-----
From: Dennis Taylor [] Sent: Monday, December 11, 2000 2:04 PM
To: Multiple recipients of list ORACLE-L Subject: being pecked to death by ducks

I need help with a question that is RTFM-able, but I'm swamped, so I'm throwing myself at everyone's mercy.

I have a full export file from a 7.3.4 database, and I need to load it into an 8.1.5 database. I know it's a relatively simple procedure, but I also remember that there's a bit of setup involved or something. The answer is somewhere in the cubic yard of Oracle manuals on my shelf, but I just don't have the time to find it right now.

I'd appreciate either instructions, or at least a pointer to the proper place in the proper manual with which to get started...

TIA [image of me dancing on numerous small fires]

Dennis Taylor
Don't worry about people stealing your ideas.  If your ideas
are any good,
you'll have to ram them down people's throats.
Please see the official ORACLE-L FAQ:
Author: Dennis Taylor

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Mon Dec 11 2000 - 14:48:16 CST

Original text of this message