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).

One 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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.