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
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
#
