Insert Fails With ORA-600 [kkqcscpopnwithmap: 0] (Doc ID 3043902.1)

Last updated on OCTOBER 01, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.23.0.0.0 and later
Information in this document applies to any platform.

ORA-600 [KKQCSCPOPNWITHMAP: 0] error occurs while executing "INSERT INTO...SELECT..." statement on DBRU 19.23 database.

The call stack is as following:

Bug 34839105 reports the same error, but it has been fixed in DBRU 19.23.

Bug 34839105 - AIM:ORA-600 [kkqcscpopnwithmap: 0] - kkqcscpopnwithmap (Doc ID 34839105.8)

This error will not occur if manually adds /*+ opt_param('_optimizer_cost_based_transformation','off') */ hint in INSERT statement.

However, DBRU 19.23 contains fix for Bug 34839105, "_optimizer_cost_based_transformation" should be applied automatically.

Run "INSERT INTO...SELECT..." statement on DBRU 19.23 database.

	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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.