Exp-00008 Oracle Error 1403 Encountered
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please exp 00008 oracle error 1403 encountered ora 01403 no data found enter a title. You can not post a blank message. Please type
Exp 00008 Oracle Error 904 Encountered
your message and try again. More discussions in Advanced Queueing All PlacesDatabaseOracle Database + OptionsAdvanced Queueing This discussion exp 00008 oracle error 6552 encountered is archived 1 Reply Latest reply on Feb 3, 2008 11:17 AM by zaffer khan, cisa ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77 - during export kogotok1 Jun 23, 2004 10:49 AM RDBMS Version: 8.1.7.3 Operating System and Version: Windows 2000 Error Number (if applicable): EXP-00008 Product (i.e. SQL*Loader, Import, etc.): Export EXP-00008: ORACLE error 1403 encountered I try to export 1 database user and get an error: . exporting posttables actions EXP-00008: ORACLE error 1403 encountered ORA-01403: no data found ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118 ORA-06512: at "SYS.DBMS_SQL", line 316 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84 ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135 ORA-06512: at line 1 EXP-00000: Export terminated unsuccessfully I've done some search on metallink for "EXP-00008: ORACLE error 1403 encount" and already found piece of advice to delete some system objects DELETE FROM SYS.EXPACT$ WHERE FUNC_PACKAGE = 'DBMS_AQ_IMPORT_INTERNAL' BUT I think it is not for me, because this database user has several queue tables: SELECT * FROM dba_queue_tables Extract from query output: CONTROL_QUEUE_TABLE OBJECT RIA.CONTROL_QUEUE_MESSAGE_T FEEDBACK_QUEUE_TABLE OBJECT RIA.FEEDBACK_QUEUE_MESSAGE_T INPUT_QUEUE_TABLE OBJECT RIA.INPUT_QUEUE_MESSAGE_T JOB_QUEUE_TABLE OBJECT RIA.JOB_QUEUE_MESSAGE_T OUTPUT_QUEUE_TABLE OBJECT RIA.OUTPUT_QUEUE_MESSAGE_T What could be the reason for the error and what could be the workaround ? Thanks in advance, Viacheslav 9852Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 77 - during export zaffer khan, cisa Feb 3, 2008 11:17 AM (in response to kogotok1) This worked for me........ (i know its an old post... but still posting the reply for oracle help wanderers) Zaffer ----------------------------------------------------------------------------------------------------------------------- Doc ID: Note:1059224.6 Subject: EXPORT FAILS WITH
on full export [message #74229] Thu, 14 October 2004 13:15 RogersJ Messages: 2Registered: October 2004 Junior Member This problem is occuring in an 8.1.7.4 database running on HPUX 11.0 I recently patched the Oracle software to meet security alert #68. This is the error when running a full export with the following parameters full=y compress=n direct=y consistent=y . about to export XXXXX's tables via Direct Path ... . . exporting table ALL_PRD_CACHED EXP-00008: ORACLE error 1403 encountered ORA-01403: no data found . exporting referential integrity constraints Tried https://community.oracle.com/thread/252990 rerunning catexp.sql - no difference Also tried: DELETE FROM SYS.EXPACT$ WHERE FUNC_PACKAGE='DBMS_AQ_IMPORT_INTERNAL'; - no difference I do not get this error when I export only XXXXX's objects. Thanks for any help. Report message to a moderator Re: EXP-00008, ORA-01403 error on full export [message #74233 is a reply to message #74229] Fri, 15 October 2004 03:09 Mahesh http://www.orafaq.com/forum/t/27111/ Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator after patching/upgrade did you run catpatch.sql? Report message to a moderator Re: EXP-00008, ORA-01403 error on full export [message #74242 is a reply to message #74233] Mon, 18 October 2004 13:14 RogersJ Messages: 2Registered: October 2004 Junior Member catpatch.sql is not part of the patch set. It also doesnot reside in $ORACLE_HOME/rdbms/admin Where would I find it ? Report message to a moderator Re: EXP-00008, ORA-01403 error on full export [message #74539 is a reply to message #74229] Mon, 03 January 2005 21:37 Raghavendra Messages: 69Registered: December 2000 Member I got following error message while exporting data EXP-00008: ORACLE error 1403 encountered pls give the solution Report message to a moderator Previous Topic: oracle server Next Topic: URGENT:-Export problem Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=37175 Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa oracle error Pirats | Start a new thread | All threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 37400 2 F. Diaz 33800 3 J. Schnackenberg 17800 4 B. Vroman 15850 5 A. Kavsek 15150 6 P. Wisse 14150 7 T. Boles 14000 8 M. Hidayathullah ... 11700 9 A. 00008 oracle error Hudspith 8700 10 A. Khan 4400 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47783Total active users2119Act. users last 24h14Act. users last hour1Registered user hits last week497Registered user hits last month6427 Go up Export terminated successfully --EXP-00008: ORACLE error 1403 Next thread: find disk not part of ASM disk group Prev thread: Email to be sent if the Datafile auto increses Message Score Author Date Hi, Our daily Export is running fine from days ...... C M Jul 10, 2009, 16:46 Have you tried the CONSISTENT=y option? There's a...... Philip Wisse Jul 14, 2009, 13:38 Hi, Bug 6151391 as mentioned in Note 462104.1. ...... C M Jul 15, 2009, 23:15 Follow up by mail Click here Subject: Export terminated successfully --EXP-00008: ORACLE error 1403 Author: C M, United States Date: Jul 10, 2009, 16:46, 2653 days ago Os info: 64 bit Window 2003 EE R2 Oracle info: 64 bit 10.2.0.