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

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


      Hi Experts,


      I like to copy the data from oracle database to 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 - 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 - 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