Get ORA-942 due to missing SYS.CSMV$KTFBUE table when running CSSCAN
(Doc ID 2194183.1)
Last updated on AUGUST 31, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
IBM z/OS on System z
Symptoms
CSSCAN is terminating unsuccessfully when running in table mode on z/OS.
csscan parfile=/u/hp02dba/csscan_parfile.txt
$ more csscan_parfile.txt
USERID=SYSTEM/<PASSWORD>
TABLE=(SYS.SQL_VERSION$)
TOCHAR=al32utf8
Character Set Scanner v2.1 : Release 10.2.0.5.0 - Production on Wed Sep 28 15:05:32 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 P13 - Production
With the Partitioning, Oracle Label Security and Data Mining options
Enter array fetch buffer size: 1024000 >
Enter number of scan processes to utilize(1..64): 1 >
Enumerating tables to scan...
ORA-00942: table or view does not exist
CSS-00151: failed to enumerate user tables
CSS-00120: failed to enumerate tables to scan
Scanner terminated unsuccessfully.
///////////////////////////////////////////////////////////////////////////
/ Oracle for OS/390 Diagnostic Trace -- 2016/10/05 20:24:06.302 /
/ System SYSx Subsystem xxxx Service ORAORA2 Session 18 PID 11F90012/
///////////////////////////////////////////////////////////////////////////
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 P13 - Production
With the Partitioning, Oracle Label Security and Data Mining options
OS/390 SP7.2.1 , CPU MODEL 2098
Instance name: ORA2
Redo thread mounted by this instance: 1
Oracle process number: 20
OSDI process pid: 11F90012, image:
*** ACTION NAME:() 2016-10-05 20:24:06.290
*** MODULE NAME:(/eis/oracle/v10g205pD/bin/csscan) 2016-10-05 20:24:06.290
*** SERVICE NAME:(SYS$USERS) 2016-10-05 20:24:06.290
*** SESSION ID:(341.5237) 2016-10-05 20:24:06.290
*** 2016-10-05 20:24:06.282
ksedmp: internal or fatal error
ORA-00942: table or view does not exist
Current SQL statement for this session:
INSERT INTO CSM$TABLES (USR#, OBJ#, BLOCKS, FILES, MINROWID, MAXROWID) SELECT O.OWNER#, O.OBJ#, S
DBMS_ROWID.ROWID_CREATE(1, O.DATAOBJ#, U.KTFBUEFNO, MIN(U
DBMS_ROWID.ROWID_CREATE(1, O.DATAOBJ#, U.KTFBUEFNO, MAX(U.KTF
0) FROM SYS.TAB$ T, SYS.OBJ$ O, SYS.CSMV$KTFBUE U, CSMIG.CSMV$EXTABLES E WHERE T.OBJ# = O.O
SEGBNO = T.BLOCK# AND U.KTFBUESEGFNO = T.FILE# AND U.KTFBUESEGTSN = T.TS# AND O.OBJ#
TAND(O.FLAGS,128)=0 AND E.PROPERTY = 0 AND BITAND(T.PROPERTY, 67108864) =0 GROUP BY O.OWN
J#, U.KTFBUEFNO
Cause
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
Symptoms |
Cause |
Solution |
References |