Ora-00920 When Exporting Whole Schema From Uss (Doc ID 740635.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 10.2.0.3
IBM z/OS (OS/390)
IBM OS/390 (MVS)

Symptoms

Export utility fails with error ora-920 when running it under USS environment. It works successfully when invoking export from client PC or from zOS side (by job) with the same export parameters.

XPRESS:/SYSTEM/tmp: >exp system/***@hope file=/tmp/exp.dmp full=y rows=n

Export: Release 9.2.0.8.21 - Production on Thu Jul 31 09:46:17 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.21 - Production
With the Partitioning and Oracle Label Security options
JServer Release 9.2.0.8.20 - Production
Export done in CL8EBCDIC1025 character set and AL16UTF16 NCHAR character set
server uses CL8EBCDIC1025R character set (possible charset conversion)
Note: table data (rows) will not be exported

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 920 encountered
ORA-00920: invalid relational operator
EXP-00000: Export terminated unsuccessfully

The characterset in USS environment is CL8EBCDIC1025. The Client Characterset in MVS side and Database server is CL8EBCDIC1025R.

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