User export failed with error EXP-00008/ORA-00904: "OLEVEL": invalid identifier

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Checked for relevance on 10-27-2010

A schema level export fails with the following errors:

exporting views
. exporting stored procedures
. exporting operators
EXP-00008: ORACLE error 904 encountered
ORA-00904: "OLEVEL": invalid identifier
EXP-00000: Export terminated unsuccessfully

Changes

The patch for Bug 5872788 was installed to try and resolve the issue.

Cause

The problem is caused by installing the fix for Bug 5872788 but not having followed the post-installation instructions mentioned in the README of the patch.

The issue has been identified in Bug 7040430 which is closed as duplicate of Bug 5872788.

Because of this the SYS.EXU81OPRU view has not been patched properly. The patched version of the view defines the OLEVEL column.

Solution

To solve the issue, follow the post-installation instructions mentioned in the README of the patch:

# Patch Special Instructions:
# ---------------------------
# Make sure all instances running under the ORACLE_HOME being patched
# are cleanly shutdown before installing this patch. Also ensure that
# the tool used to terminate the instance(s) has exited cleanly.
#
# cd rdbms/admin
# sqlplus as sysdba
# @catexp.sql
#
# If the Oracle inventory is not setup correctly this utility will
# fail. To check accessibility to the inventory you can use the
# command
#

Get Oracle Certifications for all Exams
Free Online Exams.com