import 11g dump into 10g db

[Raaj A]

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...]

Hi.

Not surprisingly, this is explained in the manual.

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

Cheers

Tim...

[Raaj A]

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...]

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...

[Raaj A]

Hi Tim,

Thank you so much for your help...

[Tim...]