My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
IBM z/OS on System z
IBM z/OS (OS/390)
IBM OS/390 (MVS)


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 - Production on Thu Jul 31 09:46:17 2008

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

Connected to: Oracle9i Enterprise Edition Release - Production
With the Partitioning and Oracle Label Security options
JServer Release - 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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.