This forum is currently locked. You can't register or post questions at this time. (read more)

Data Transfer from 10g to 11g

All posts relating to Oracle database administration.

Moderator: Tim...

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

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron