dbdao吧 关注:1,189贴子:4,072
  • 6回复贴,共1

低版本exp导高版本db出现错误

只看楼主收藏回复

刘大,麻烦看下
dbserver: 11.2.0.4.0 - 64bit
client1: 11.2.0.4.0 - 64bit
client2: 11.2.0.1.0 - 64bit
1.用exp做表分区导出:
exp **/**@upay file=**_RESULT_20160120.dmp tables=**.TXN_**:P20160120 grants=n indexes=n buffer=10240000 statistics=none
在client1上正常。
在client2上报错:
About to export specified tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "DUMMYFLAG": invalid identifier
EXP-00000: Export terminated unsuccessfully
2.用exp做整表导出时都正常
查询了mos发现bug13248730
Bug 13248730 : EXP 11.1.0.7 CONNECTING TO DB 11.2.0.2 THROWS ORA-904
但并无11.2.0.1 客户端和11.2.0.4的描述,想请问下刘大这个是不是bug


1楼2016-01-22 14:19回复
    1.用exp做表分区导出:
    ==> 什么版本?
    11.2.0.1 exp有问题, 11.2.0.4 exp有无问题?


    IP属地:日本2楼2016-01-22 14:28
    回复
      数据库服务器版本:11.2.0.4
      11.2.0.1版本exp导出有问题
      11.2.0.4版本exp导出没有问题


      3楼2016-01-22 14:31
      回复
        表分区是范围+哈希的组合分区


        4楼2016-01-22 14:34
        回复
          $ exp */*@upay file=*_RESULT_20160120.dmp tables=*.*_RESULT:P20160120 grants=n indexes=n buffer=1024
          0000 statistics=none log=11.2.0.1.log
          Export: Release 11.2.0.1.0 - Production on Thu Jan 21 23:41:04 2016
          Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
          Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
          With the Partitioning, OLAP, Data Mining and Real Application Testing options
          Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
          Note: grants on tables/views/sequences/roles will not be exported
          Note: indexes on tables will not be exported
          About to export specified tables via Conventional Path ...
          EXP-00008: ORACLE error 904 encountered
          ORA-00904: "DUMMYFLAG": invalid identifier
          EXP-00000: Export terminated unsuccessfully


          5楼2016-01-22 14:35
          回复
            errorstack描述和MOS上相同:
            Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
            With the Partitioning, OLAP, Data Mining and Real Application Testing options
            Release: 2.6.32-358.el6.x86_64
            Version: #1 SMP Tue Jan 29 11:47:41 EST 2013
            Machine: x86_64
            Instance name: upay
            Redo thread mounted by this instance: 1
            Oracle process number: 28
            Unix process pid: 23947, image: oracle@dbserver
            *** 2016-01-22 14:58:12.119
            *** SESSION ID:(17.3309) 2016-01-22 14:58:12.119
            *** CLIENT ID:() 2016-01-22 14:58:12.119
            *** SERVICE NAME:(upay) 2016-01-22 14:58:12.119
            *** MODULE NAME:(exp@mysql (TNS V1-V3)) 2016-01-22 14:58:12.119
            *** ACTION NAME:() 2016-01-22 14:58:12.119
            dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
            ----- Error Stack Dump -----
            ORA-00904: "DUMMYFLAG": invalid identifier
            ----- Current SQL Statement for this session (sql_id=dsrbhwszh22fw) -----
            SELECT OBJID, DOBJID, SUBPNAME, TSNAME, FILENO, BLOCKNO, TSNO, PROWCNT, PBLKCNT, PAVGRLEN, BLEVEL, LEAFCNT, DISTKEY, LBLK
            KEY, DBLKKEY, CLUFAC, HIBOUNDLEN, HIBOUNDVAL, dummyflag FROM SYS.EXU81TBSPU WHERE POBJID = :1 ORDER BY SUBPARTNO
            ----- Call Stack Trace -----
            calling call entry argument values in hex
            location type point (? means dubious value)
            -------------------- -------- -------------------- ----------------------------
            skdstdst()+41 call kgdsdst() 000000000 ? 000000000 ?
            7FFF6CEC0660 ? 7FFF6CEC0738 ?
            7FFF6CEC51E0 ? 000000002 ?


            6楼2016-01-22 15:18
            回复
              楼主有11.2.0.4的客户端安装包么。。。求一个
              xuwei_417@126.com


              IP属地:湖南7楼2016-09-07 16:43
              回复