OraFAQ Forum: Server Administration » Oracle Export Import Utility Different Versions

Home » RDBMS Server » Server Administration » Oracle Export Import Utility Different Versions (AIX 6.1 64bit - Oracle 10gR2 (10.2.0.5.0))

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

Oracle Export Import Utility Different Versions [message #554056]

Thu, 10 May 2012 03:36

Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines

Junior Member

We are migrating
from [IBM P5 - AIX 5.3 - Oracle DB 10.2.0.1 64bit]
to [IBM P7 - AIX 6.1 - Oracle DB 10.2.0.5 64bit]

The new database is already up and running, our next step now is the following:
1. Create Tablespaces (done)
2. Export the Database from P5
3. Import the dump to P7.

We have this following options:

I. Use a Windows XP workstation 32bit with Oracle 10.2.0.1 Database software to export from P5, then import the dump to P7. (Export/Import Utility 10.2.0.1 Windows 32bit)

II. Use the Export Utility of the P7 (10.2.0.5 AIX 64bit) to do the export and import.

III. Use the Export Utility of P5 (10.2.0.1 AIX 64bit) then use the Import Utility of P7 (10.2.0.5 AIX 64bit)

Can someone give me an advice what to do? And what problem might I encounter?

BTW, our colleague tried to do the following:
A. Use Windows - Export Utility 10.1.0.2.0 - 32bit to make a dump of our database (Oracle 10.2.0.1.0 AIX 64bit)
B. Use Windows - Import Utility 10.1.0.2.0 - 32bit to import the dump file from step A to our new database (Oracle 10.2.0.1.0 AIX 64bit)

But after issuing
imp system/password@NEWDB file=(a.dmp, b.dmp... c.dmp) full=y ignore=y statistics=none

The import seems to hang here...
importing SYSTEM's objects into SYSTEM

Report message to a moderator

Re: Oracle Export Import Utility Different Versions [message #554059 is a reply to message #554056]

Thu, 10 May 2012 03:44

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If possible, Use import Data Pump in P7 to directly import the custom objects through network (db link), no export needed.
Do not use old export/import utilities for this.

Regards
Michel

Report message to a moderator

Re: Oracle Export Import Utility Different Versions [message #554063 is a reply to message #554059]

Thu, 10 May 2012 03:56

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

@Michel, I would be interested to know if you have found the network mode to perform well for large operations, such as this. The last time I tried it, network mode was actually slower than an export then an import. I never found out why. I was changing several things: 11.1.0.6 to 11.2.0.2, Sun v490 to Sun T3-2, UFS to ZFS, EE to SE.
Is it possible that network mode always uses the external table path, not the direct path?

Report message to a moderator

Re: Oracle Export Import Utility Different Versions [message #554065 is a reply to message #554063]

Thu, 10 May 2012 04:20

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I would be interested to know if you have found the network mode to perform well for large operations, such as this

The problem is that you can't really use parallelism with network import.
It is indeed less performant than an export/import but it has the advantage to be easy to use.
If time is an issue then it is better to export in parallel then import, I always use this mode when operation is large.

Quote:

Is it possible that network mode always uses the external table path, not the direct path?

I have to admit I don't know (and didn't search for till now).

Regards
Michel

Report message to a moderator

Re: Oracle Export Import Utility Different Versions [message #554125 is a reply to message #554065]

Thu, 10 May 2012 08:32

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Thank you for sharing your experience, it is nice to know that it isn't just me.

And back to the original question, the easiest way to see if Data Pump is hanging or working is to query v$session_longops.

Report message to a moderator

Re: Oracle Export Import Utility Different Versions [message #554126 is a reply to message #554125]

Thu, 10 May 2012 08:54

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Note that OP didn't use Data Pump but old export/import, the first to do for him is to use Data Pump (in parallel mode).

Regards
Michel

Report message to a moderator

Previous Topic:	Cannot start listener (/tmp related)
Next Topic:	Cause of invalid objects

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 22:32:56 CDT 2024