oracle1455解决方法,oracle_1455_错误解决办法.doc

oracle_1455_错误解决办法.doc

ORACLE1455错误解决办法ORA01455转换列溢出整数数据类型在用EXPUSER/PWDORACLESIDFILEE\ABC530DMP导出ORACLEDMP时报错了，错误如下EXP00056ORACLEERROR1455ENCOUNTEREDORA01455CONVERTINGCOLUMNOVERFLOWSINTEGERDATATYPEEXP00000EXPORTTERMINATEDUNSUCCESSFULLY在网上查了查都是ORA01455转换列溢出整数数据类型,EXPORT命令会将表的STATISTICS值转成成整形。当这个STATISTICS值超过2311时，就会报这个错误。最后在EXP命令后加“INDSNSTATISTICSNONE”这两个参数，EXPUSER/PWDORACLESIDFILEE\ABC530DMPINDSNSTATISTICSNONE就可以成功导出了。HTTP//BLOGCSDNNET/TIANLESOFTWARE/ARTICLE/DETAILS/6251652ORACLEEXPEXP00008和ORA01455CONVERTINGCOLUMNOVERFLOWSINTEGERDATATYPE的解决方法分类ORACLE故障解决案例201103151915914人阅读评论1收藏举报ORACLE用EXP导出数据库的时候，可能会遇到这个错误ENCOUNTERINGERRORSINEXPORTLOGFILEEXP00008ORACLEERRORENCOUNTEREDORA01455CONVERTINGCOLUMNOVERFLOWSINTEGERDATATYPE当我们在EXP命令加上参数INDSNSTATISTICSNONE后就不会报这个错误。导致这个错误原因EXPORT命令会将表的STATISTICS值转成成整形。当这个STATISTICS值超过2311时，就会报这个错误。解决方法1通过DBA_TABLES和DBA_INDS来查看对应表的值。即NUM_ROWS值，看是否超过了2311。如果表的NUMROWS超过了，可以手工的修改表的这个值，如SQLCUTESYSDBMS_STATSSET_TABLE_STATS SCOTT , EMP ,NUMROWS1000000000000该命令格式DBMS_STATSSET_TABLE_STATS,,2删除对应的统计信息表SQLANALYZETABLEDELETESTATISTICS索引SQLANALYZEINDEXDELETESTATISTICS或者使用CUTESYSDBMS_STATSDELETE_INDEX_STATSOWNNAME SCOTT ,INDNAME MY_INDX_1 CUTEDBMS_STATSDELETE_TABLE_STATS(OWNNAME SCOTT ,TABNAME TABLE_NAME )修改完之后，在导，就没有问题了。BLOGHTTP//BLOGCSDNNET/TIANLESOFTWARE网上资源HTTP//TIANLESOFTWAREDOWNLOADCSDNNET相关视频HTTP//BLOGCSDNNET/TIANLESOFTWARE/ARCHIVE/2009/11/27/4886500ASPXDBA1群62697716满DBA2群62697977满DBA3群62697850满DBA超级群63306533满DBA4群83829929DBA5群142216823聊天群40132017加群需要在备注说明ORACLE表空间和数据文件的关系，否则拒绝申请HOWDOIFIXORA01455ERRORON11GRELEASE2ORACLEDATABASEINTRODUCTIONTODAY,USINGMYTESTORACLE11GRELEASE2ONONEVIRTUALMACHINE,TOTESTTHEEXPORTOFONESCHEMAIWASEXPORTINGSCHEMAN112DATABASEWITH10GCLIENTTHEEXPORTGAVEANORA01455THEEXPORTFAILEDWITHTHEFOLLOWINGDETAILEDERROREXPORTINGREFERENTIALINTEGRITYCONSTRAINTSEXPORTINGTRIGGERSEXP00056ORACLEERROR1455ENCOUNTEREDORA01455CONVERTINGCOLUMNOVERFLOWSINTEGERDATATYPEEXP00000EXPORTTERMINATEDUNSUCCESSFULLYIREMEMBERIHAVESOLVEDTHISISSUEONEMONTHAGOWHENONEORACLEUSERPOSTEDTHEISSUEONTHEOTNFORUMIHELPHIMTOFIXTHEISSUEAFTERFIXINGTHEPROBLEM,ITHOUGHTITWOULDBEAGOODIDEATOPOSTTHESOLUTIONHERESOEVERYONECANSOLVEITINTHEFUTURETHEERROREXPORTINGREFERENTIALINTEGRITYCONSTRAINTSEXPORTINGTRIGGERSEXP00056ORACLEERROR1455ENCOUNTEREDORA01455CONVERTINGCOLUMNOVERFLOWSINTEGERDATATYPEEXP00000EXPORTTERMINATEDUNSUCCESSFULLYTHISISANORACLEBUGTHEROOTCAUSEISTHATTHECONVERTEDOFTHESPECIFIEDEXPRESSIONWASTOOLARGEFORTHESPECIFIEDDATATYPEFROMORACODECOMWEBSITESOLUTIONIHAVEFIXEDTHEPROBLEMUSINGONEOFTHEFOLLOWINGSOLUTIONS,THEREFORE,THISCANNOTOFFERANYGUARANTEEOFFIXFORSUCHSITUATIONSSOLUTION1TRYWITHANORACLE11GRELEASE2EXPCLIENTAGAINSTTHEORACLE11GRELEASE2SOLUTION2USETHETRIGGERSNOPTION,THATALLOWSANEXPORTOFASCHEMAMADEBYANORACLE102CLIENTAGAINSTANORACLE11GRELEASE2TOCOMPLETESUCCESSFULLYTHEARTICLEISALSOPOSTEDHEREINORACLEMIXHTTPS//MIXORACLECOM/GROUP_MESSAGES/149104HOWDOIFIXORA01455ERRORON11GRELEASEORACLEDATABASENICEREADINGANDTHANKYOU,WISSEMELKHLIFISQLPLUS/ASSYSDBASQLNOAUDITSESSIONTHENEXPORTAGAI