当前位置:首页 > 开发 > 数据库 > 正文

ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.

发表于: 2013-12-01   作者:czmmiao   来源:转载   浏览次数:
摘要: ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.(exp) (Doc ID 957380.1)  APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Relea

ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.(exp) (Doc ID 957380.1) 
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 08-Apr-2013***
SYMPTOMS
ORA-904 occurs when using a release 11g export client to export from release 10g database.
Export succeeds when using any 10gR2 export client.
Example:
Using export client (11.1.0.7) to export from 10.2.0.4 database
exp scott/****** file=d:\exp.dmp
Export: Release 11.1.0.7.0 - Production on Fri Oct 2 10:14:24 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P15 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table BONUS
EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table DEPT
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table EMP
EXP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table SALGRADE
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
Analysis shows this occurs when the following query is run by export client:
ksedmp: internal or fatal error
ORA-00904: "MAXSIZE": invalid identifier
Current SQL statement for this session:
SELECT INIEXT, SEXT, MINEXT, MAXEXT, PCTINC, BLOCKS, LISTS, GROUPS, EXTENTS, PCACHE, TS_TYPE, TSNAME, ISONLINE, BLOCKSIZE, HSCOMPRESS, MAXSIZE FROM SYS.EXU9STOU WHERE FILENO = :1 AND BLOCKNO = :2 AND TSNO = :3
CAUSE
When export any objects export client run a query agains dictionary view SYS.EXU9STOU to gather storage parameters about object segments.
Since release 11g this view has been updated by a new column MAXSIZE. When using the release 11g export client the utility expects the MAXSIZE column SYS.EXU9STOU of source database.
Given the fact that this column is unavailable in 10g the ORA-904 is reported.
11g
---
SQL> descr SYS.EXU9STOU;
 Name                          Null?    Type
 ----------------------------- -------- ------------------
 OWNERID                       NOT NULL NUMBER
 TSNO                          NOT NULL NUMBER
 FILENO                        NOT NULL NUMBER
 BLOCKNO                       NOT NULL NUMBER
 INIEXT                        NOT NULL NUMBER
 SEXT                          NOT NULL NUMBER
 MINEXT                        NOT NULL NUMBER
 MAXEXT                        NOT NULL NUMBER
 PCTINC                        NOT NULL NUMBER
 BLOCKS                        NOT NULL NUMBER
 LISTS                                  NUMBER
 GROUPS                                 NUMBER
 EXTENTS                       NOT NULL NUMBER
 PCACHE                                 VARCHAR2(7)
 TS_TYPE                                NUMBER
 TSNAME                                 VARCHAR2(30)
 ISONLINE                               NUMBER
 BLOCKSIZE                              NUMBER
 HSCOMPRESS                             NUMBER
 MAXSIZE                                NUMBER
SOLUTION
Please use the release 10g export client to export from a 10g database.
Once the export dump has been created you have to use the release 11g import client to import into your 11g database.
Additional information will you find in Note 132904.1 - Compatibility Matrix for Export And Import Between Different Oracle Versions.

 

参考至:https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=184073240717388&id=957380.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=1byvugjnzk_61

如有错误,欢迎指正

邮箱:czmcj@163.com

ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

编辑推荐
www.oracle.com/technetwork/cn/server-storage/linux/python-091105.html Connecting to Oracle im
一,简介 二,配置虚拟机 1,创建虚拟机 (1)添加三块儿网卡: 主节点 二节点 eth0: 公网 192.168.1.
1. IOC - Inversion of Control 控制反转 IOC的基本概念是:不创建对象,但是描述创建它们的方式。
中国互动网china-pub新品: Oracle Database 9i/10g/11g编程艺术:深入数据库体系结构:第2版 久负盛
Spring 3.0M3 及其以后的版本包含了JavaConfig 项目提供的大部分功能. 如果你的程序遭遇如下异常: E
一、操作系统 l Windows Server 2003 l Windows 2000 SP1 l Windows XP Professional l Windows NT
February 15 How to deploy an Analysis Services database using a script Deploying an OLAP appl
http://innovating-technology.blogspot.com/2013/04/mysql-hadoop-applier-part-1.html MySQL repl
Problem I am trying to backup SharePoint 2013 Farm Automatically with PowerShell and Windows
Problem I am trying to backup SharePoint 2013 Farm Automatically with PowerShell and Windows
版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号