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

import 11g dump into 10g db

General suggestions and comments about the forums.

Moderator: Tim...

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

import 11g dump into 10g db

Postby Raaj A » Mon Dec 10, 2012 8:37 am

Hi Tim,

Can i import schema dump file created in( oracle 11g (11.1.0.6) into 10g(10.2.0.4.0)? I tried this using expdp and impdp on my UAT system but getting compatibility error.

Is there any document where export-import between different oracle versions( forword and backward) compatibility are mentioned?

Please Help..


Thanks Raaj

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

Re: import 11g dump into 10g db

Postby Tim... » Mon Dec 10, 2012 9:24 am

Hi.

Not surprisingly, this is explained in the manual. :)

http://docs.oracle.com/cd/B28359_01/ser ... m#CEGFCFFI

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

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Re: import 11g dump into 10g db

Postby Raaj A » Tue Dec 11, 2012 10:24 am

Hi Tim,

As per your suggestion i created export file in 11g(11.1.0.6) using expdp and version parameter. On the target database which is on 10g(10.2.0.4) i dropped the schema, recreated schema and given all the appropriate grants. While importing using below command....

c:> impdp tril/tril@dbname schemas=tril directory=test_dir dumpfile=filename.dmp logfile=abc.log

got the error...

error " ORA-31684: Object type USER:"TRIL" already exists "

As per my understanding this error should not come because before importing we have recreated schema. Rest everything is imported perfectly..(objects like tables,procedures,functions,packages)..

please help..

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

Re: import 11g dump into 10g db

Postby Tim... » Tue Dec 11, 2012 6:59 pm

Hi.

You get the error because you manually created the user, then the import attempted to create it and therefore failed.

The error message can be ignored. If you want to avoid it in future, either don't create the user before the import, or exclude the create of the user from the import.

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

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Re: import 11g dump into 10g db

Postby Raaj A » Wed Dec 12, 2012 4:31 am

Hi Tim,

Thank you so much for your help...

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

Re: import 11g dump into 10g db

Postby Tim... » Wed Dec 12, 2012 7:32 am

:)
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 “Suggestions and Comments”

Who is online

Users browsing this forum: No registered users and 3 guests

cron