OraFAQ Forum: Server Utilities » Importing Oracle 8.1.7 dump file into Oracle 8.1.6

Home » RDBMS Server » Server Utilities » Importing Oracle 8.1.7 dump file into Oracle 8.1.6

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

Importing Oracle 8.1.7 dump file into Oracle 8.1.6 [message #71535]

Wed, 20 November 2002 21:04

Hasan Mannan
Messages: 5
Registered: November 2002

Junior Member

Hi,
This is Hasan (Database Administrator), I have exproted a user from oracle 8.1.7, but now the problem is that i wana import that dump file into another Database which of versoin 8.1.6
Can any body help me in this regard, that how can i import that dump file in previous version.
Thankx in advance

Hasan.

Report message to a moderator

Re: Importing Oracle 8.1.7 dump file into Oracle 8.1.6 [message #71538 is a reply to message #71535]

Thu, 21 November 2002 02:45

B
Messages: 327
Registered: August 1999

Senior Member

u can' use Ur dump ...

Try this.
set env to 816
run exp user/passwd@DB817 [[OPTIONS]]

and now U'll have a 816 compatible dmp

Report message to a moderator

Re: Importing Oracle 8.1.7 dump file into Oracle 8.1.6 [message #71564 is a reply to message #71535]

Fri, 22 November 2002 22:42

sharan alva
Messages: 57
Registered: November 1999

Member

Hasan,
Export is not backward compatible. i.e. if you have already exported from 8.1.7 then you cannot import it using the 8.1.6 export.

There are a couple of options of doing it.
1 - set Oracle_home to 8.1.6 and sid to 8.1.7 run catexp.sql, this will create 8.1.6 compatible export views. Then export 8.1.7
Once this is done set O_H back to 8.1.7 and run the catexp to bring it back to it's original state.

2 - as posted in the previous reply.

Sharan

Report message to a moderator

Re: Importing Oracle 8.1.7 dump file into Oracle 8.1.6 [message #71585 is a reply to message #71538]

Tue, 26 November 2002 07:21

Susanne Schneider
Messages: 5
Registered: March 2002

Junior Member

>set env to 816
What do you mean by this?

Does this method also done the trick for a reimport into Oracle 8.1.6 from Oracle 9?

Sorry for the newbie-question and
TIA
Susanne

Report message to a moderator

Re: Importing Oracle 8.1.7 dump file into Oracle 8.1.6 [message #71910 is a reply to message #71585]

Mon, 03 February 2003 11:49

doug held
Messages: 1
Registered: February 2003

Junior Member

So... is this as effective as running the EXPAT scripts from 816 on 817, exporting and then running the 817 EXPAT scripts?

If so, why would anyone even give that advice? This is so much easier.

Report message to a moderator

Previous Topic:	assigning default value null to IN and OUT variables in a stored procedure for DB2
Next Topic:	Sqlloader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 20:25:08 CDT 2024