Query Fails With ORA-600 [ztsmdwl failed] When Accessing Encrypted Column (Doc ID 550229.1)

Last updated on MARCH 08, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
Information in this document applies to any platform.

Symptoms

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

 

or

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

or 

kzekmetc kzecsqen kzecctex evaopn2 evaopn2 insLoadRow ...
_$#$_

Cause

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