Export Fails with EXP-00024

While you’re trying to export schemas with original export (exp) utility, if export fails with “EXP-00024: Export views not installed, please notify your DBA” message, problem is probably about forgetting to update the catalog metadata which is used by export tool:

You can run the following script to create export catalogs but it’s not enough:

After running catexp, if you try to export again, you’ll get the following error:

So you shutdown the database, open in migrate mode (or upgrade mode if your DB is 10g+) and patch the catalog:

Please share
  •  
  •  
  •  
  •  
  •  
  •  

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

5 Comments

  1. V R Murthy Korimilli

    Hi,

    Thanks for the above useful post.

    Just to be more clear on the last point, for Oracle 10g we use catupgrd.sql. catpatch.sql applies only to Oracle 9i.

    Regards,

    V R Murthy Korimilli

Leave Comment

Your email address will not be published. Required fields are marked *

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