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 an Oracle Big Data Analytics Consultant with great interest in anything closely related to the Oracle Big Data Analytics (OBIEE, BICS, OAC, Big Data, Data Integration, Data Visualization, Data Management, Data Architecture).

1 thought on “Solving “EXP-00056: ORACLE error 932 encountered””

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s