Solving “EXP-00056: ORACLE error 932 encountered”

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

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”

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: Logo

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

Connecting to %s

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