Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: exp errors-correction

Re: exp errors-correction

From: Joan Hsieh <jhsieh_at_infonet.tufts.edu>
Date: Fri, 15 Sep 2000 10:36:29 -0400
Message-Id: <10620.117108@fatcity.com>


This solution is working perfectly. Yesterday I deleted all those rows against TEST database. Somehow I export testing against DEV. Oh boy, what a day.

Joan

Joan Hsieh wrote:
>
> Well, I found this on metalink. But after I follow the instruction to
> deleted all the rows and rerun the full export. I still get same errors.
> I guess I have to call support. (By the way, I tried to rerun
> catlog,catprc. didn't help either)
>
> Joan
>
> EXP-8: ORACLE error 1403 encountered
> ORA-1403: no data found
> ORA-6512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 69
> ORA-6512: at line 1
> ORA-6512: at "SYS.DBMS_SYS_SQL", line 787
> ORA-6512: at "SYS.DBMS_SQL", line 328
> ORA-6512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
> ORA-6512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
> ORA-6512: at line 1
> EXP-0: Export terminated unsuccessfully
>
> User/Table level exports are fine, re-running of catalog and catproc
> make
> no difference.
>
> Problem Explanation:
> ====================
>
> This can be caused by running the script 'catnoqueue.sql' without first
> dropping all the queue tables in the database. See [BUG:647800] which
> is
> fixed in 8.0.6.
>
> Problem References:
> ===================
> [BUG:647800]
>
> Solution: DELETE FROM SYS.EXPACT$ WHERE FUNC_PACKAGE
> ='DBMS_AQ_IMPORT_INTERNAL';
>
> Solution Explanation
> ====================
> The script 'catnoqueue.sql' has been run which drops the tables
> DEF$AQCALL
> and DEF$AQERROR. The corresponding rows in SYS.EXPACT$ are not dropped.
>
> Prior to running 'catnoqueue.sql', check for and drop any existing
> queue tables.
>
> To ascertain the existence of any queue tables, from SQL*Plus issue
> the following command to list all queue tables:
> SELECT * FROM dba_queue_tables
>
> To drop the queue tables, from SQL*Plus issue the following command:
> execute dbms_aqadm.drop_queue_table('<queue table name>')
>
> Solution Description:
> =====================
>
> If 'catnoqueue.sql' has already been run, then you need to delete from
> SYS.EXPACT$ rows for non-existent queue tables.
>
> The following steps will allow a full export to run successfully:
> All rows from the SYS.EXPACT$ table for the function package
> DBMS_AQ_IMPORT_INTERNAL need to be deleted.
>
> 1. Login into Server Manager as INTERNAL or SYS; or, login into
> SQL*Plus as
> SYS
>
> 2. Enter the following SQL command:
>
> DELETE FROM SYS.EXPACT$
> WHERE FUNC_PACKAGE = 'DBMS_AQ_IMPORT_INTERNAL';
>
> After the statement issue a 'commit' so the statement can take effect.
>
> 3. Exit Server Manager or SQL*Plus.
>
> 4. Now you should be able to do a full database export.
>
> Ruth Gramolini wrote:
> >
> > What was the answer? RBG
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, September 14, 2000 3:45 PM
> >
> > > Hi listers,
> > >
> > > Never mind, I found the solution.
> > > Thanks,
> > >
> > > Joan
> > >
> > > Joan Hsieh wrote:
> > > >
> > > > Hi Listers,
> > > >
> > > > I just found our daily full export (direct path) has those error
> > > > messages at the botton of log file.
> > > > ......
> > > > . about to export REPORT's tables via Direct Path ...
> > > > . exporting referential integrity constraints
> > > > . exporting posttables actions
> > > > EXP-00008: ORACLE error 1403 encountered
> > > > ORA-01403: no data found
> > > > ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 72
> > > > ORA-06512: at line 1
> > > > ORA-06512: at "SYS.DBMS_SYS_SQL", line 787
> > > > ORA-06512: at "SYS.DBMS_SQL", line 328
> > > > ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
> > > > ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
> > > > ORA-06512: at line 1
> > > > EXP-00000: Export terminated unsuccessfully
> > > > Thu Sep 14 13:36:18 EDT 2000
> > > > Finished Export.
> > > >
> > > > All the database objects are valid.
> > > > Any ideas ?
> > > >
> > > > Thanks,
> > > > Joan
> > > > --
> > > > Author: Joan Hsieh
> > > > INET: jhsieh_at_infonet.tufts.edu
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing Lists
> > > > --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > > --
> > > Author: Joan Hsieh
> > > INET: jhsieh_at_infonet.tufts.edu
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Sep 15 2000 - 09:36:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US