My Oracle Support Banner

HOWTO : Resolve TimesTen Error 6221: Temporary data partition free space insufficient to allocate N bytes of memory When NLS_SORT=BINARY_CI Is Used (Doc ID 789614.1)

Last updated on AUGUST 11, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version and later
Information in this document applies to any platform.


Customers may encounter situations where a query performing an order-by or other sort operation completes with relatively little temporary space required when NLS_SORT value is either not enabled or set to BINARY. However, when NLS_SORT is altered to BINARY_CI, that same query fails and exhausts all available temp space.

The following errors may be returned:

802: Data store space exhausted
6221: Temporary data partition free space insufficient to allocate 20212 bytes of memory

 The query continues to fail with the TT802 and TT6221 space errors even when temporary space in the datastore is greatly increased.


Problem occurs only when NLS_SORT=BINARY_CI (case-insensitive) is enabled, i.e.,

Alter Session set NLS_SORT=BINARY_CI;


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.