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 126.96.36.199 to 10.2.0.3 [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 188.8.131.52.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 184.108.40.206.21 - Production
With the Partitioning and Oracle Label Security options
JServer Release 220.127.116.11.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.
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