Exp-00056 Oracle Error 1013 Encountered
Contents |
08, 2010 - 10:36 am UTC Category: Database – Version: version 7.3.2.3 Latest Followup You Asked Dear Tom, recently (last week actually!) I started exporting some of my Bases via MS-DOS direct to my PC using either 'exp' or 'exp80' depending
Exp 00056 Oracle Error 12154 Encountered
on the Base. With one of them (Bases that is!)I keep on getting the following exp 00056 oracle error 1017 encountered error 'exporting table TDATOSGENERALES EXP-00014: error on row 583691 of table TDATOSGENERALES EXP-00008: ORACLE error 1013 encountered ORA-01013: user requested cancel of
Exp 00056 Oracle Error 1034 Encountered
current operation exporting table TDATOSGENERALESANT 778522 rows exported etc etc. This error is random i.e occuring on different tables every time I attempt to export but always with the same Schema/User. There is absolutely no activity ora-01013 timeout parameter on that Schema when it happens so can you help me find a solution. My first thought was that it was something to do with the size of the table as it seems to occur only on tables with large number of rows but what is driving me up the wall is the randomness of it! I did see the archive where you speak about this viz. a viz SQLPlus and Unix terminals etc. Do you know if the equivilant of 'stty isig' exists in the MS-DOS world. My PC is running W95 and the Base I am trying to export is Oracle 7.3.2.3 I would like to take this opportunity to thank you for the most usefull response you gave me recently viz. a viz ORA-1555 and Export. The support note 40689.1 was most comprehensive and clear. While I am on the subject can you tell me where I can find an archive of Support notes on the OTN, or if such a thing exists. If 40689.1 was anything to go by I feel I might progress faster with my Oracle education with them rather than the manuals! Regards, Michael and we said... Well, yet another support note to the rescue maybe..... Article-ID:
phenomenon and treatment Watch ...... 1 Question phenomenon [Oracle @ RH207 exp] $ exp test / test file = test.dmf log = test.log Ignored ...... ...... EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. .. Exporting table SNP_TXT 6345 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. .. Exporting table SNP_TXT_CROSSR 1019 rows exported EXP-00091: Exporting questionable statistics. https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:704225010478 EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00008: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation EXP-00056: ORACLE error 1403 http://www.databasesql.info/article/7617303051/ encountered Ignored ...... ...... 2 Processing Method NLS_LANG environment variable specified Linux system data sets 1) many query the database character set (only one) SQL> select userenv ('language') from dual; USERENV ('LANGUAGE') -------------------------------------------------- - AMERICAN_AMERICA.WE8ISO8859P1 2) Set the Linux operating system NLS_LANG environment variable [Oracle @ RH207 exp] $ export NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 Window System environment variable modification method is: C: \> set NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 3.OK processing is complete, making EXP export operation does not report this error 09.04.21 - The End - Recommended Mysql Stored procedure: delimiter string is divided into a multi-column! Spatial database implementation strategy - raster data HR table ATM system [15] - Authentication class [00 original] JAVA Chinese character display solutions to problems Nanjing software companies introduced one by one and computer learning that the exchange of experience IMA brief introduction How to change the column order of oracle table structure SQL Server transaction log © Copyright 2015-2016databasesql.infoContact
【知识库】深度学习知识图谱上线啦 EXP-00091处理! 标签: tableoracleparameterstransactionscharacteruser 2009-08-10 11:20 2782人阅读 评论(0) 收藏 举报 本文章已收录于: 版权声明:本文为博主原创文章,未经博主允许不得转载。 EXP-00091: Exporting questionable statistics. 5 rows exported EXP-00091: Exporting questionable statistics. . . exporting table NEW_CATEGORY 169 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table http://blog.csdn.net/henrybai/article/details/4430108 NEW_PROJECT^C EXP-00056: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation . . exporting table NEW_TASK^C EXP-00056: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation . . exporting table PROJECT_TYPES^C EXP-00056: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation . . exporting table TASK_TYPES^C EXP-00056: ORACLE oracle error error 1013 encountered ORA-01013: user requested cancel of current operation . about to export OPS$ORACLE's tables via Conventional Path ...^C EXP-00056: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation^C^C EXP-00000: Export terminated unsuccessfully $ sqlplus / SQL*Plus: Release 9.2.0.7.0 - Production on Mon Aug 10 14:03:42 2009 Copyright (c) 1982, 2002, 00056 oracle error Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production SQL> select * from v$nls_parameters where 2 parameter='NLS_CHARACTERSET'; PARAMETER ---------------------------------------------------------------- VALUE ---------------------------------------------------------------- NLS_CHARACTERSET UTF8 SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production $ set NLS_LANG=AMERICAN_AMERICA.UTF8 $ export NLS_LANG=AMERICAN_AMERICA.UTF8 $ exp / file=cpprd_full.dmp full=y Export: Release 9.2.0.7.0 - Production on Mon Aug 10 14:06:28 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production Export done in UTF8 character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporti