The Fix For Bug 7568350 Generates ORA-00904: "POLTYP" Error At Export Client (Doc ID 784038.1)

Last updated on JANUARY 29, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Jan-2015***

Symptoms

When running full database export using the traditional export utility (exp) started from remote client, the following errors will be returned:

EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully


The 904 event trace file shows the following statement:

ORA-00904: "POLTYP": invalid identifier
Current SQL statement for this session:
SELECT POLGRP, POLTYP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED, SPOLICY
FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM = :2

Changes

The issue occurs while running a client export from an ORACLE_HOME with <Patch 7568350> installed against a database which hasn't the fix for <Bug 7568350> applied to the RDBMS Home.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms