Re: Oracle 10G export issues after patch was installed EXP-00008

"Teresa" <tpreto7_at_sapo.pt> wrote in message news:1131221277.582876.118000_at_o13g2000cwo.googlegroups.com...
> Hello
>
> Since I applied oracle patch Im getting errors while exporting the
> database, I have already re installed the patch and run all the scripts
> and about 2 times the catpatch.sql and still I get the following
> errors while exporting any schema, although if I export only 1 table I
> don't get any errors at all, Oracle version is 10.1.0.4.0 on solaris
> 5.8
>
>
> Export done in UTF8 character set and AL16UTF16 NCHAR character set
> server uses WE8ISO8859P1 character set (possible charset conversion)
> . exporting pre-schema procedural objects and actions
> EXP-00008: ORACLE error 6550 encountered
> ORA-06550: line 1, column 13:
> PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
> EXP-00083: The previous problem occurred when calling
> EXFSYS.DBMS_EXPFIL_DEPASEX
> P.schema_info_exp . exporting foreign function library names for user
> MYUSER
>
> Why is there so many issues with oracle 10G with exports?
>

Hi,

I had simular problems with 10.1.0.4 on AIX. Had to install 2 patches to get export working errorfree : 1 AIX specific patch, another one for Workspace Manager. Do you have a support contract ? I would create a TAR on Metalink.

Matthias Received on Sat Nov 05 2005 - 16:35:26 CST