Aline,
O que vou colocar abaixo foi tirado do Metalink, veja se o que está sendo
falado se encaixa na sua versão de banco.
----------------------------------------------------------------
Doc ID: Note:1059224.6
Subject: Export Fails With EXP-8, ORA-4068 / ORA-1403 on
SYS.DBMS_AQ_IMPORT_INTERNAL
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 01-OCT-1998
Last Revision Date: 16-AUG-2004
Problem Description:
====================
Your full database export fails when exporting posttables actions
with the following errors:
. exporting posttables actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
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
or:
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]
<ml2_documents.showDocument?p_id=647800&p_database_id=BUG>
which is
fixed in 8.0.6.
Problem References:
===================
[BUG:647800] <ml2_documents.showDocument?p_id=647800&p_database_id=BUG>
Solution Explanation
====================
The script 'catnoque.sql' has been run by mistake. This script drops
the tables DEF$AQCALL and DEF$AQERROR. The corresponding rows in
SYS.EXPACT$ are not dropped. This script was only intented to remove
the Advance Queue Option during an 8.0.4 upgrade. Removing AQ is no longer
an option. The script has not been included in 9i releases but exists
for all 8i releases.
Under no circumstances should this script be run !
If user queues and queue tables exist in the database when catnoque is run,
it does NOT drop them. It merely drops the dictionary objects, views and
packages needed to administer them. Similar messages to those generated
by
catproc will be generated for user defined queues and queue tables when
they are dropped and created.
If the script has been accidentally executed, it has corrupted the
data dictionary. All queues, queue tables and their corresponding dictionary
entries must be manually cleaned up. Only after that can catproc be
successfully executed. Catproc will recreate all the necessary objects
required by Advanced Queuing.
Solution Description:
=====================
If 'catnoque.sql' has been run by mistake (do not run this script!),
a workaround for the full database export is to delete the reference to
the queue tables fro the table SYS.EXPACT$.
1. Login into Server Manager as INTERNAL or SYS;
or:
Login into SQL*Plus as SYS
2. Enter the following SQL commands:
SELECT * FROM sys.expact$ WHERE func_package = 'DBMS_AQ_IMPORT_INTERNAL';
CREATE TABLE sys.expact$_backup AS SELECT * FROM sys.expact$;
DELETE FROM sys.expact$ WHERE func_package = 'DBMS_AQ_IMPORT_INTERNAL';
COMMIT;
3. Exit Server Manager or SQL*Plus.
4. Now re-run the full database export.
----------------------------------------------------------------
Espero ter ajudado.
Marcos Vieira
'>'----- Original Message -----
'>' From: Aline Rios
'>' To: Aline Rios
'>' Sent: Thursday, September 08, 2005 12:32 PM
'>' Subject: [oracle_br] export full - URGENTE
'>'
'>'
'>' Pessoal, boa tarde!
'>' Estou tentando fazer um export do banco, mas não estou conseguindo
e estou
'>'obtendo o seguinte erro:
'>'
'>' 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
'>'
'>' Já procurei algumas soluções na internet, mas gostaria de saber se
alguém
'>'já passou por isso e como resolveu de fato.
'>'
'>' Muito obrigada a todos!
'>' Sds,
'>' Aline.
'>'
'>'
'>'
'>'[As partes desta mensagem que não continham texto foram removidas]
'>'
'>'
'>'
'>'______________________________________________________________________
'>'
'>'Histórico: http://www.mail-archive.com/[email protected]/
'>'Falar com os Moderadores:([EMAIL PROTECTED])
'>'Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar
'>'______________________________________________________________________
'>'Links do Yahoo! Grupos
'>'
'>'
'>'
'>'
'>'
'>'
'>'
______________________________________________________________________
Histórico: http://www.mail-archive.com/[email protected]/
Falar com os Moderadores:([EMAIL PROTECTED])
Dorian Anderson Soutto - Fernanda Damous - Alisson Aguiar
______________________________________________________________________
Links do Yahoo! Grupos
<*> Para visitar o site do seu grupo na web, acesse:
http://br.groups.yahoo.com/group/oracle_br/
<*> Para sair deste grupo, envie um e-mail para:
[EMAIL PROTECTED]
<*> O uso que você faz do Yahoo! Grupos está sujeito aos:
http://br.yahoo.com/info/utos.html
