Re: exp errors

From: Joan Hsieh <jhsieh_at_infonet.tufts.edu>
Date: Thu, 14 Sep 2000 16:29:23 -0400
Message-Id: <10619.117016@fatcity.com>

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.

Login into Server Manager as INTERNAL or SYS; or, login into SQL*Plus as SYS
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 Thu Sep 14 2000 - 15:29:23 CDT