Data Transfer from 10g to 11g

All posts relating to Oracle database administration.

Moderator: Tim...

Data Transfer from 10g to 11g

Postby aunshakeel » Wed Sep 26, 2012 1:04 pm

hi all,
I am suppose to take an expdp export from 10gRAC servers and import it to 11gRAC servers.
Do i have to shut the listeners before taking export and taking import ont he two servers.
Will there be any issues if i perform this task without shutting the listeners down.
if i do shutdown the listeners will it affect the import and export.

Thank you
aunshakeel
Member
 
Posts: 35
Joined: Tue May 05, 2009 6:38 am

Re: Data Transfer from 10g to 11g

Postby Tim... » Thu Sep 27, 2012 11:04 am

Hi.

No. You don't need to shut down the listeners.

You should export from 10g using the 10g version of expdp (on the 10g servers) and import the dump file into 11g using the 11g version of impdp (on the server). Provided you do that it will work fine.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 10 guests