Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import table space created by Oracle 12c in Oracle 10g.

80323e17-d60a-4665-b99e-469d0820481aAug 25 2016 — edited Aug 25 2016

Hi ,

I have two database instances Oracle 12c(version: 12.1.0.2.0) and other Oracle 10g (version:10.2.0.1.0 ).

I am trying to create a transportable tablespace dump from 12 c instance using the below mentioned command:

expdp sems12@pdoe/sems12 dumpfile=test_ps.dmp directory=source_pmp_directory transport_tablespaces=TBS_PS metrics=y exclude=statistics version=10.2.0.1.0

I am getting error in the dump creation

Export: Release 12.1.0.2.0 - Production on Thu Aug 25 06:49:21 2016

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ORA-39001: invalid argument value

ORA-39250: Using version to downgrade a transportable job is not supported

But on the oracle documentation of Datapump export and import its mentioned that the value of version can be greater than 9.2.

https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_export.htm#i1007148

Is it possible to create a tablespace export dump from Oracle 12c(version: 12.1.0.2.0) to be compatible for import in Oracle 10g (version:10.2.0.1.0 )?

Thanks

Shashank Garg

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2016

Added on Aug 25 2016

#database-key-features, #replication

0 comments

889 views