Solving “EXP-00056: ORACLE error 932 encountered”

When I was trying to export a schema out of an Oracle Database; 10g Release 10.2.0.1.0.

After a while I was faced with the following error; “EXP-00056: ORACLE error 932 encountered”

After a little bit of Googlin’ I found a solution on the Oracle OTN Forum. Thanks to ‘slappyjam’ I was able to solve my problem.

** Solution  **

Run following scripts while connected as SYS user:

sqlplus /nolog

SQL> connect / as sysdba
SQL> @?/rdbms/admin/catmetx.sql
SQL> @?/rdbms/admin/utlrp.sql

SQL> exit

The export ended succesfully; “Export terminated successfully without warnings”

Author: Daan Bakboord

I am a Self Employed Oracle Data & Analytics Consultant with a great interest in anything closely related to Oracle Big Data Analytics (OBIEE, BICS, OAC, Big Data, Data Integration, Data Visualization, Data Management, Data Architecture). View all posts by Daan Bakboord