低版本exp导高版本db出现错误
dbdao吧
全部回复
仅看楼主
level 3
伊万罗夫 楼主
刘大,麻烦看下
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
2016年01月22日 06点01分 1
level 13
1.用exp做表分区导出:
==> 什么版本?
11.2.0.1 exp有问题, 11.2.0.4 exp有无问题?
2016年01月22日 06点01分 2
level 3
伊万罗夫 楼主
数据库服务器版本:11.2.0.4
11.2.0.1版本exp导出有问题
11.2.0.4版本exp导出没有问题
2016年01月22日 06点01分 3
level 3
伊万罗夫 楼主
表分区是范围+哈希的组合分区
2016年01月22日 06点01分 4
level 3
伊万罗夫 楼主
$ 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
2016年01月22日 06点01分 5
level 3
伊万罗夫 楼主
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 ?
2016年01月22日 07点01分 6
level 1
楼主有11.2.0.4的客户端安装包么。。。求一个
[email protected]
2016年09月07日 08点09分 7
1