Query Fails With ORA-600 [ztsmdwl failed] When Accessing Encrypted Column
(Doc ID 550229.1)
Last updated on FEBRUARY 04, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
1. ORA-600 [ztsmdwl failed] error occurs on SQL that accesses tables with encrypted columns.
2. The trace file shows a large failing select statement with many subselects. This error has also been seen when attempting to load data into a table with encrypted columns which also has complex columns (e.g. varrays) via SQL*Loader direct path mode.
Known Error stacks:
kzekmetc kzecctex evaopn2 evaopn2 qerhjSplitProbe qerhjInnerProbeHashTable kdstf1101101kmP kdsttgr qertbFetch rwsfcd qerhjFetch qerflFetchOutside qeruaFetch qerghFetch opifch2 opifch . . .
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