Exp-00008 Oracle Error 600 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 exp-00008 oracle error 904 encountered ora-00904 invalid identifier to my PC using either 'exp' or 'exp80' depending on the Base. With oracle error 904 ora-00904 invalid identifier one of them (Bases that is!)I keep on getting the following error 'exporting table TDATOSGENERALES EXP-00014: error on row 583691 exp 00008 oracle error 1003 encountered of table TDATOSGENERALES EXP-00008: ORACLE error 1013 encountered ORA-01013: user requested cancel of current operation exporting table TDATOSGENERALESANT 778522 rows exported etc etc. This error is random i.e occuring on different tables error code 904 oracle every time I attempt to export but always with the same Schema/User. There is absolutely no activity 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
Ora-00904: Invalid Identifier
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: SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB exp-00008 oracle error 1555 encountered Don Burleson Blog Exp 00008 Oracle Error 3113 Encountered
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get https://www.experts-exchange.com/questions/20880939/ORA-00600-internal-error-code-arguments-12700-when-export-dump.html Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORA-00600: internal error code, arguments: [12700] when export dump Want to Advertise Here? Solved ORA-00600: internal error code, arguments: [12700] when export dump Posted on 2004-02-11 Oracle Database 1 Verified Solution 3 Comments 1,514 Views Last Modified: 2007-12-19 Hi, My database is Oracle 8.1.7 Enterprise oracle error Edition when i export dump (exp globus/pwd@ file=globus.dmp log=globus.txt the process abort with message below: EXP-00008: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [12700], [18], [4201234], [72], [], [], [], [] EXP-00000: Export terminated unsuccessfully I checking de trace file (ORA00340.TRC), appear de follow text: ORA-00600: internal error code, arguments: [12700], [18], [4201234], [72], [], [], [], [] Current SQL statement for this session: SELECT LOWNER, LIBNAME, OWNERID, FILENAME, 00008 oracle error OBJNO, AUDIT$,ISSTATIC, ISTRUSTED FROM SYS.EXU8LIBU The oracle said: check if de data object is corrupt: (obj= EXU8LIBU). ANALYZE TABLE EXU8LIBU VALIDATE STRUCTURE; But this obj is a view then return error: ORA-01702: a view is not appropriate here. How can i to solve this case? thank´s 0 Question by:junior_soares Facebook Twitter LinkedIn Google LVL 4 Best Solution bykalosi Hi, if you have access to metalink follow the instructions at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=155933.1&p_database_id=NOT. you are facing a block corruption Go to Solution 3 Comments LVL 4 Overall: Level 4 Oracle Database 1 Message Expert Comment by:kalosi2004-02-11 The EXU8LIBU view constist of the following tables: obj$, user$, library$ run analyze on them while I will check metalink weather any known issue exists. david 0 LVL 4 Overall: Level 4 Oracle Database 1 Message Expert Comment by:kalosi2004-02-11 Hi - in Oracle 8.x and 9.x, it is ORA-600 [12700][a][b][c] , where Arg [a] dataobj# from sys.obj$ Arg [b] relative dba of the data block Arg [c] slot number of the row in the data block please run the following query, somehow I think it will return the line with the obj$ object. select * from obj$ where dataobj# = 18 david 0 LVL 4 Overall: Level 4 Oracle Database 1 Message Accept