OraFAQ Forum: Server Utilities » impdp to different version

Home » RDBMS Server » Server Utilities » impdp to different version (11.2.0.3)

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

impdp to different version [message #635175]

Mon, 23 March 2015 11:47

varunvir
Messages: 389
Registered: November 2007

Senior Member

Experts,

My production database is on 11.2.0.3 and UAT on 11..2.0.4.
I want to take export using expdp from production and then import to UAT using impdp.
My question:-
Is it possible to export from lower and then import higher versions?

Thanks,

Varun

[Updated on: Mon, 23 March 2015 11:48]

Report message to a moderator

Re: impdp to different version [message #635176 is a reply to message #635175]

Mon, 23 March 2015 11:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is it possible to export from lower and then import higher versions?
yes

why bother us asking here instead of just trying it yourself?

Report message to a moderator

Re: impdp to different version [message #635177 is a reply to message #635175]

Mon, 23 March 2015 11:50

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Afaik, it is very much possible.

Did you try? Was there any error?

Report message to a moderator

Re: impdp to different version [message #635191 is a reply to message #635175]

Tue, 24 March 2015 04:19

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

From the documentation:
Quote:

Data Pump Import can always read dump file sets created by older releases of the database.

So, just from 11.2.0.3 to 11.2.0.4 is definitely no problem.

Report message to a moderator

Previous Topic:	ORA-01400: cannot insert NULL
Next Topic:	Import and create table from a text file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 22 07:45:13 CDT 2026