3 Replies Latest reply: Jul 3, 2013 9:35 AM by Mark D Powell

How to perform datacopy from 10gr2 to 11gr2 database?

906790 Jul 3, 2013 6:45 AM

Hi Experts,

I like to copy the data from 10.2.0.4 oracle database to 11.2.0.3 db, so i tried to fired the traditional export from 11gr2 db server throw network.Please find the below error which i got while fired the export.

==> exp system/*******@EMP file=emp_3July2013.dmp owner=emp statistics=none log=emp_3July2013.log

Export: Release 11.2.0.3.0 - Production on Wed Jul 3 07:36:35 2013

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

About to export specified users ...

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user EMP

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user EMP

About to export EMP's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export EMP's tables via Conventional Path ...

EXP-00008: ORACLE error 904 encountered

ORA-00904: "POLTYP": invalid identifier

EXP-00000: Export terminated unsuccessfully

Thanks

1. Re: How to perform datacopy from 10gr2 to 11gr2 database?

Aravind N Jul 3, 2013 7:02 AM (in response to 906790)

Hi,
This is a known bug and is documented in MOS document ID 784038.1
If you are not particular about using exp/imp, try expdp and impdp which would be faster as well. Else you might have to apply the patch mentioned to fix this.
-Aravind
Like Show 0 Likes (0)

Actions
2. Re: How to perform datacopy from 10gr2 to 11gr2 database?

Paul M. Jul 3, 2013 7:07 AM (in response to 906790)

I like to copy the data from 10.2.0.4 oracle database to 11.2.0.3 db, so i tried to fired the traditional export from 11gr2 db server throw network

Apart that you should use expdp, you can't export a database using an exp utility from an higher version, you have to export using 10g exp utility, and import using 11g imp utility.

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

Couldn't this be a problem ? You should set NLS_LANG environment variable before exporting and importing.
Like Show 0 Likes (0)

Actions
3. Re: How to perform datacopy from 10gr2 to 11gr2 database?

Mark D Powell Jul 3, 2013 9:35 AM (in response to Paul M.)

I agree with Paul that if you are going to use exp you must use the 10.2 version to perform the export which the 11.2 imp can then process. If you use expdp to run the export then you should be able to use the 11.2 version providing you specify the version= parameter to identify that an older database is being read.

HTH -- Mark D Powell --
Like Show 0 Likes (0)

Actions

Go to original post