Oracle Error 1003 Encountered
Contents |
ORACLE error 1003 encountered If this is your first visit, be sure to check out the FAQ by clicking the link
Exp-00008: Oracle Error 904 Encountered
above. You may have to register before you can post: click the exp-00008 oracle error 904 encountered ora-00904 invalid identifier register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 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
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site http://www.dbasupport.com/forums/showthread.php?33690-EXP-00008-ORACLE-error-1003-encountered By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Oracle: Oracle release - 9i and earlier Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesOracle: Oracle release - 9i and earlier Forum ORA-01003: no statement parsed thread759-469294 Forum Search FAQs Links MVPs ORA-01003: no statement parsed ORA-01003: no statement parsed ratfink (IS/IT--Management) (OP) http://www.tek-tips.com/viewthread.cfm?qid=469294 7 Feb 03 08:47 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 errorsEXP-00008: ORACLE error 1003 encounteredORA-01003: no statement parsedEXP-00008: ORACLE error 904 encounteredORA-00904: invalid column namePlease help! RE: ORA-01003: no statement parsed karluk (MIS) 7 Feb 03 13:32 According to Metalink note 106155.1, this type of error is most likely caused by a version mismatch between the database and the export utility.Perhaps installing the 8.1.6.3.8 patch created the mismatch.The suggested fix is to rerun catalog.sql and catproc.sql as sys.That, among other things, will recreate your export views.There appear to be other causes of this error.The Metalink note says that a large export that exceeds your file size limit can also create this type of error. Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Re
EXP-00008: ORACLE error 6552 encountered [message #575203] Mon, 21 January 2013 05:02 deepak416 Messages: 63Registered: January http://www.orafaq.com/forum/t/185830/ 2013 Location: Pune Member Hi i am facing with "EXP-00008: http://ejvyas.blogspot.com/2012/08/ora-00904-maxsize-invalid-identifier.html 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. oracle error Connected to: Oracle Database 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 ... oracle error 904 . . exporting table SBRSAI2GCOVER EXP-00008: ORACLE 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 err
11.2.0.3. My export activity was terminated due to this error: EXP-00008: ORACLE error 904 encountered ORA-00904: "MAXSIZE": invalid identifier EXP-00000: Export terminated unsuccessfully This was what I got from Oracle Support: Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2 Information in this document applies to any platform. ***Checked for relevance on 22-SEP-2011*** Symptoms ORA-904 occurs when using a release 11g export client to export from release 10g database. Export succeeds when using any 10g export client (10.2.0.1 ... 10.2.0.4). 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 i