다음의 스크립트를 sys 유져 권한으로 실행 하신후 다시한번 export 작업을 수행해 보세요..

$ORACLE_HOME/rdbms/admin/catmeta.sql 

metalink 에서 확인해보니 XDB 관련 View 들에 문제가 있어서 이런현상이 발생하는 것 같습니다.

아래는  metalink의 참고 문서입니다.

=====================================================================

보낸 사람: Alex Brasier 22-Feb-03 22:30
제목: Fatal EXPORT termination - ORA0600 and ORA19206

RDBMS Version: 9.2.0.1.0
Operating System and Version: Windows XP 2002 SP1
Error Number (if applicable): ORA-0600
Product (i.e. SQL*Loader, Import, etc.): Export Utility
Product Version: 9.2.0.1.0

Fatal EXPORT termination - ORA0600 and ORA19206

EXP-00056: ORACLE error 600 encountered
Hello,
I am doing an export using the following parameters:
FULL=Y
GRANTS=Y
INDEXES=Y
CONSISTENT=Y

(all other parameters are as defaults)

I get the following error messages and then fatal termination when running my export script (the script has worked many times before without this problem)!

. exporting cluster definitions
ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [],
[]
ORA-19206: Invalid value for query or REF CURSOR parameter
EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kpotcpop1], [], [], [], [], [], [],
[]
ORA-19206: Invalid value for query or REF CURSOR parameter
EXP-00000: Export terminated unsuccessfully

보낸 사람: Oracle, Helen Schoone 04-Mar-03 21:01
제목: Re : Fatal EXPORT termination - ORA0600 and ORA19206

Hi. I believe your error is due to bug 2228054 which is an issue regarding XML views and export. The workaround is to run $ORACLE_HOME/rdbms/admin/catmeta.sql connected as SYS AS SYSDBA. You should then be able to restart the export.

There is an article which discusses the issue and workaround available from the MetaLink Advanced Search option by Doc ID:

Doc ID: 206313.1 ORA-19206 EXP-00056 While Taking Export

The ORA-600 error appears to merely be a side effect of the ORA-19206.

Regards,
Helen
Oracle Support Services

================================================================

Fact:

-----

Oracle Server Version 9.2.0.1

Export Version 9.2.0.1

Symptom:

---------

During export you receive the following errors:

EXP-00056: ORACLE error 19206 encountered

ORA-19206: Invalid value for query or REF CURSOR parameter

ORA-06512: at "SYS.DBMS_XMLGEN", line 83

ORA-06512: at "SYS.DBMS_METADATA", line 345

ORA-06512: at "SYS.DBMS_METADATA", line 410

ORA-06512: at "SYS.DBMS_METADATA", line 449

ORA-06512: at "SYS.DBMS_METADATA", line 1156

ORA-06512: at "SYS.DBMS_METADATA", line 1141

ORA-06512: at line 1

EXP-00056: ORACLE error 19206 encountered

EXP-00000: Export terminated unsuccessfully

Cause:

------

XDB installation/dictionary built causes some of the underlying XML views to be INVALID. 

Here the error occurs when dbms_xmlgen tries to access one those invalid views.

Fix:

----

Run the following script that resides under 

$ORACLE_HOME/rdbms/admin directory after XDB dictionary is built

by connecting as user SYS :

catmeta.sql (Creates Object Model of Oracle dictionary) 

After running this script, start the export of  database again.