Home » RDBMS Server » Backup & Recovery » Importing data from export with Different version
Importing data from export with Different version [message #151080] Tue, 13 December 2005 00:54 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
I have two different databases(on different machines)

DB01
i have exported from one database with export utility version
8.1.7.0.0
(Datbase Oracle9i Enterprise Edition Release 9.2.0.1.0-Production)

DB02
Now i want to import it to database having export(import) utility version 9.0.1.1.1
9.(Datbase Oracle9i Enterprise Edition Release 9.0.1.1.1-Production)

what i will need to do?
please suggest

Thanks in advance
Pratap

Report message to a moderator

Re: Importing data from export with Different version [message #151088 is a reply to message #151080] Tue, 13 December 2005 01:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use the same 8.1.7.0.0 version of imp to import into 9i database.
Invoke import session from the same machine you started export.
All you need , a tnsservice name to talk to the 9i database.

imp dba/user@9idatabase....

Report message to a moderator

Re: Importing data from export with Different version [message #151102 is a reply to message #151088] Tue, 13 December 2005 02:51 Go to previous message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Mahesh,
Many thanks for such a fast reply!!
as usual u have helped a lot

Best Regards,
Pratap

Report message to a moderator

Previous Topic: RMAN backup failure through veritas netbackup
Next Topic: hello
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 10:15:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.