Skip to Main Content
Forums

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!

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

906790Jul 3 2013 — edited Jul 3 2013

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

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

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
This post has been answered by Paul M. on Jul 3 2013
Jump to Answer

Comments

Aravind N

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

1 person found this helpful
Paul M.
Answer 
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.

Marked as Answer by 906790 · Sep 27 2020
Mark D Powell

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


1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 31 2013
Added on Jul 3 2013
#database-key-features, #export-import-sql-loader-external-tables
3 comments
564 views