Oracle Error 1003 Encountered No Statement Parsed
ORACLE error 1003 encountered If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start exp-00008: oracle error 904 encountered viewing messages, select the forum that you want to visit from the selection below. Results exp-00008 oracle error 904 encountered ora-00904 invalid identifier 1 to 10 of 10 Thread: EXP-00008: ORACLE error 1003 encountered Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-07-2003,09:04 AM #1 ratfink View Profile View Forum Posts Junior Member Join Date Mar 2002 Posts 25 EXP-00008: ORACLE error 1003 encountered I have an 8.1.6 database patched to a 8.1.6.3.8. The database seems happy while it is running, but when I do an exp I get two errors EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed EXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name Please help! Reply With Quote 02-07-2003,09:15 AM #2 jovery View Profile View Forum Posts Visit Homepage Ha Ha Join Date Jan 2002 Location Up s**t creek Posts 1,525 Have you rerun catalog/catproc since patching the database? Regards Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website! Reply With Quote 02-07-2003,10:31 AM #3 ratfink View Profile View Forum Posts Junior Member Join Date Mar 2002 Posts 25 Yes I did. I just ran them again to be sure. I did another export and got identical errors. Reply With Quote 02-07-2003,10:35 AM #4 adewri View Profile View Forum Posts Visit Homepage Oracle Monk Join Date Nov 2002 Location New Delhi, INDIA Posts 1,796 try running catexp.sql (i know its included in the catalog.sql) and spool the output and see if any signnificant error is there. Amar "There is a difference between knowing the path and walking the path." Reply With Quote 02-07-2003,10:37 AM #5 Mr.Hanky View Profile View Forum Posts X-Mas poo Join Date Jan 2001 Posts 3,134 How are you doing this export? Are you uing command line, parfile? MH I remember when this place was cool. Reply With Quote 02-07-2003,10:55 AM #6 ratfink View Profile View Forum Posts Junior Member Join Date Mar 2002 Posts 25 Actually I did run catexp.sql too - I tried that first. I am running a .bat file - I use this same format on all of the
EXP-00008: ORACLE error 6552 encountered [message #575203] Mon, 21 January 2013 05:02 deepak416 Messages: 63Registered: January 2013 Location: Pune Member Hi i am facing with "EXP-00008: ORACLE error 6552 encountered" error please help me Configuration read [Tue Jan 15 09:54:50 IST 2013] [INFO] Directory is present Export: Release 10.2.0.1.0 - Production on Tue Jan 15 09:55:07 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database http://www.dbasupport.com/forums/showthread.php?33690-EXP-00008-ORACLE-error-1003-encountered 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Export done in US7ASCII character set and AL32UTF8 NCHAR character set server uses AL32UTF8 character set (possible charset conversion) About to export specified tables via Conventional Path ... . . exporting table SBRSAI2GCOVER EXP-00008: ORACLE http://www.orafaq.com/forum/t/185830/ error 6552 encountered ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-553: character set name is not recognized . . exporting table SBRSAI3GCOVER EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRSAIFAPIDOVERRIDE EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRSAIFAPIDSAI EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRBLMFAPLCDEXCLUSIONLIST EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRSAIDEFAULT EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRBLMFAPIDADSLPORTLOCATION EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRUEREGISTER EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRBLMSTATS EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRBLMTRAPS EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table SBRFEMTOAP EXP-00008: ORACLE
position(http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html). I am maintaining this http://halimdba.blogspot.com/2010/07/exp-00008-oracle-error-904-encountered.html blog for helping myself while in work and sharing http://anilanbu.blogspot.com/2012/01/user-export-failed-with-error-exp.html my knowledge with others. If you have any question. you can reach me at infohalimdba@gmail.com Thanks. Home Oracle 12c DBA Training SQL & PL/SQL Training Dataguard 12c Training RAC 12c Training Consulting & Support Linux Contact Us Reviews oracle error Thursday, July 8, 2010 EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier ORA-01003: no statement parsed EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier ORA-01003: no statement parsed--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------=============================================================When I execute a export (EXP) in this version I found this result............................-------------------------------------------------------------------------------------------------------------------------------------------------------==============================================================SQL*Plus: Release 11.1.0.6.0 - Production on oracle error 904 Thu Jul 8 13:00:12 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.SQL> hostMicrosoft Windows XP [Version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:\Documents and Settings\era-1>exp userid=basel2/basel2@test107 owner=basel2file=D:\basel_dump\basel2_08072010_test107.dmp LOG=D:\basel_dump\basel2_08072010_test107.LOGExport: Release 11.1.0.6.0 - Production on Thu Jul 8 13:00:19 2010Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setAbout to export specified users .... exporting pre-schema procedural objects and actions. exporting foreign function library names for user BASEL2. exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user BASEL2About to export BASEL2's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export BASEL2's tables via Conventional Path .... . exporting table AUDIT_SOURCE_HISTEXP-00008: ORACLE error 904 encountered
identifier User export failed with error EXP-00008/ORA-00904: "MAXSIZE"/"OLEVEL": invalid identifier EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table DMI_DIST_COMP_RECORD_R EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier . . exporting table DMI_DIST_COMP_RECORD_S EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table DMI_DUMP_OBJECT_RECORD_S EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier . . exporting table DMI_EXPR_CODE_S EXP-00008: ORACLE error 1003 encountered ORA-01003: no statement parsed . . exporting table DMI_INDEX_R Cause: Depends upon the version mismatch. like if you trying to take a export from 11.x.x.x.x home to 10.x.x.x.x dump file, you will get this error. Solution: If you want to take exp from db version 10.x.x.x.x serious, try it from some other database with same version. example: cd /opt/oracle/product/11.1.0.7/db_1/bin ./exp system/password@10gdb(tnshostname)full=y file=/oradata/export/prod007.dmp log==/oradata/export/prod007.log you will get below error... User export failed with error EXP-00008/ORA-00904: "MAXSIZE": invalid identifier see MetalinkID :-741984.1 Posted by Anbazhagan Renganathan at 9:54:00 pm Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) ABOUT ME Anbazhagan Renganathan View my complete profile LABELS Oracle (82) Unix (15) தமிழ் (8) SEARCH THIS BLOG BLOG ARCHIVE ► 2014 (10) ► November (1) ► September (1) ► August (3) ► July (2) ► March (1) ► January (2) ► 2013 (32) ► December (6) ► November (2) ► October (2) ► September (1) ► August (5) ► June (1) ► May (15) ▼ 2012 (14) ► May (1) ► March (3) ► February (5) ▼ January (5) User export failed with error EXP-00008/ORA-00904:... RMAN-03002, RMAN-06403, ORA-01034, ORA-27101: shar... ORA-00059: maximum number of DB_FILES exceeded ORA-01092, ORA-01501, ORA-00450, ORA-00444, ORA-00... ORA-12560: TNS Protocol adapter error on Windows ► 2011 (51) ► December (32)