Hello,I have a question in exporting database,hoping anybody can give me a hand.I execute EXP command with a file as parameter.But an error occured.If you can help me,please give me an email.Giving an answer here is just ok.Thanks.
The information is as these:

bash-2.03# exp scott/tiger parfile = test.dat

Export: Release 8.1.5.0.0 - Production on Fri May 21 11:40:55 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR characteret

About to export specified tables via Conventional Path ...
. . exporting table SYSTEM_OUTRESOURCE_INFO
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 25:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Export terminated successfully with warnings.

My guess is that CATEXP did not get run when creating the database which creates the export utility ... this is a standalone script, but must be run connected as INTERNAL ...

HTH
Gregg

Thanks.I will try it.
Glad to meet guys here.ThoughI am a newbie coming from China ,I feel good to make friends with guys here.Actually,my name is 于 科，and “yuke” is its pronounciation.

The errors indicate that $ORACLE_HOME/rdbms/admin/CATALOG.SQL and $ORACLE_HOME/rdbms/admin/CATPROC.SQL should be run again.

Make sure you run them connected as SYS. Then check for invalid objects:

SQL> SELECT OBJECT_NAME, OBJECT_TYPE FROM DBA_OBJECTS WHERE STATUS = 'INVALID' AND OWNER = 'SYS';

Is DBMS_EXPORT_EXTENSION still invalid? If so, try compiling it manually:

SQL> ALTER PACKAGE DBMS_EXPORT_EXTENSION COMPILE BODY;


Hope that helps,

clio_usa - OCP 8/8i/9i DBA