OraFAQ Forum: Server Utilities » how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6

Home » RDBMS Server » Server Utilities » how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6

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

how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6 [message #70384]

Wed, 05 June 2002 20:47

ravikr
Messages: 9
Registered: June 2002

Junior Member

hi,

My problem is I have (exported) created a dump file using oracle8.1.5 version's exp command. Later on I want to import the dump file into oracle8.0.6 version which was created using oracle8.1.5. But i get error messages when I try to import the dump file.

can anyone help me out to solve this problem?

thanks
with regards
ravi.k.r

Report message to a moderator

Re: how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6 [message #70389 is a reply to message #70384]

Thu, 06 June 2002 18:00

seng
Messages: 191
Registered: February 2002

Senior Member

Try use 8.1.5 imp .. hope this is helping

Report message to a moderator

Re: how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6 [message #70391 is a reply to message #70384]

Thu, 06 June 2002 20:41

ravikr
Messages: 9
Registered: June 2002

Junior Member

hi seng,

my problem is I want to dump the export file created in 8i into oracle 8.0.

Report message to a moderator

Re: how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6 [message #70405 is a reply to message #70384]

Mon, 10 June 2002 08:35

Grant
Messages: 578
Registered: January 2002

Senior Member

Use the 8.0.6 export utility/binary on the 8.1.5 DB.

Report message to a moderator

Re: how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6 [message #70408 is a reply to message #70391]

Mon, 10 June 2002 17:46

seng
Messages: 191
Registered: February 2002

Senior Member

here is the main step in this downupgrade. You need to export utility(v8.0) from 8i database and import utility (v8.0) back to 8.0 database. hope this is helping.

Report message to a moderator

Re: how do i import a dump file created in oracle 8.1.5 into oracle 8.0.6 [message #70466 is a reply to message #70384]

Mon, 17 June 2002 23:12

Sreedhar
Messages: 30
Registered: March 2000

Member

Ravi,

What error u are getting.. while importing into the 806.
>Is both the homes are in the same box?
> is compatability parameter is setted in the init.ora?
>did u set the path in 806 environment?

Check all of the above.. let me know.. the above so that I can help you more..

-Sreedhar

Report message to a moderator

Previous Topic:	Urgent - Loading from one flatfile to two tables - Getting wrong results
Next Topic:	SQLLDR 8.1.5 will not exit after sucessfull load

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 04:05:08 CDT 2024