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

Home -> Community -> Usenet -> c.d.o.server -> Re: Export problem

Re: Export problem

From: <holmesb_at_my-dejanews.com>
Date: Wed, 12 May 1999 11:15:56 GMT
Message-ID: <7hbnt9$rlg$1@nnrp1.deja.com>


In article <373949b7.0_at_news.ll.iac.es>,   "Éric DANTIE" <edantie_at_rcanaria.es> wrote:
> I'm using Oracle 8.0.5 for solaris.
>
> When I am trying to export whole database (as user sys or system, with
all
> default parameters) I've got this error:
> [...]
> . exporting posttables actions
> EXP-00008: ORACLE error 4045 encountered
> ORA-04045: errors during recompilation/revalidation of
> SYS.DBMS_AQ_IMPORT_INTERNAL
> ORA-06552: PL/SQL: Compilation unit analysis terminated
> ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
> 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-00222:
> System error message 2
> EXP-00000: Export terminated unsuccessfully
>
> Any idea?
>
> Thanks in advance
>
> In svrmgrl run catqueue.sql. You can then check the status of the
objects w/dba_objects. If this does not correct the problem, rerun catalog.sql, catproc.sql, and catexp.sql in rdbms/admin.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 06:15:56 CDT

Original text of this message

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