Ora-00920 When Exporting Whole Schema From Uss
Last updated on APRIL 24, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11 to 10.2.0.3
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 18.104.22.168.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 22.214.171.124.21 - Production
With the Partitioning and Oracle Label Security options
JServer Release 126.96.36.199.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.
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