My Oracle Support Banner

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 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 . . .



ksedst ksedmp ksfdmp kgerinv kgeasnmierr BEEF260 kzekmetc BEEF260 FFFFFFFF kzecsqen kzecctex evaopn2
evaopn2 insLoadRow


kzekmetc kzecsqen kzecctex evaopn2 evaopn2 insLoadRow ...


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.