My Oracle Support Banner

OGG-00017 Not enough stack space error with OGG-00869 No unique key is defined for table (Doc ID 1624335.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


On : version, 1 - Oracle DB backend

When attempting to replicate a table,
the following errors occur.

OGG-00869 No unique key is defined for table 'table-name'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key. Using following columns in default map by name: (200+ columns listed)
OGG-00017 Not enough stack space. Specify FUNCTIONSTACKSIZE greater than 200.

The issue can be reproduced at will with the following steps:
1. Attempt to re-instantiate the table using import, but get unique key violations
2. Drop the unique key and import successfully.
3. Start GoldenGate EXTRACT and REPLICAT
4. REPLICAT reports OGG-00869 and OGG-00017 errors


 The Unique Index was dropped on the table being replicated


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.