Oracle 9i export unsuccessful since patch update.

pts.
Tags:
Oracle
Hi, i'm quite new to oracle, i've got an oracle 9i database been running 1 year, which runs an export every night. Everything has been working fine on 9.2.0.1.0. I updated straight to 9.2.0.7.0. Everything else looks ok. Users, still happy. Now export fails with: Connected to: Oracle9i Release 9.2.0.7.0 - Production JServer Release 9.2.0.7.0 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please notify your DBA EXP-00000: Export terminated unsuccessfully

Answer Wiki

Thanks. We'll let you know when a new response is added.

You must run the CATEXP.SQL or CATALOG.SQL script to install the views and give privileages to the EXP_FULL_DATABASE role.

I would start with CATEXP.SQL since that seems to be the only thing that doesn’t work. Apparently that got missed in you upgrade. CATALOG.SQL eventually executes CATEXP.SQL after doing many other tasks.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Charliep
    It looks like you did not run catpatch.sql which upgrades the data dictionary. That would be a post-install step.
    0 pointsBadges:
    report
  • ColinM
    You might fix this by running the $ORACLE_HOME/rdbms/admin/catexp.sql script, otherwise, beat up tech support.
    10 pointsBadges:
    report
  • aglking
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-9i-export-unsuccessful-since-patch-update... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following