My Oracle Support Banner

Extract Abended With Error "ORA-00942: table or view does not exist, SQL< select value$ from sys.props$ where name = 'NLS_LANGUAGE'>" (Doc ID 1274300.1)

Last updated on JANUARY 22, 2020

Applies to:

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

Symptoms

When attempting to start an Extract, we get error

2010-12-09 18:59:25 GGS ERROR 182 OCI Error describe for query (bad syntax) (status = 942-ORA-00942: table or view does not exist), SQL< select value$ from sys.props$ where name = 'NLS_LANGUAGE'>.

2010-12-09 18:59:25 GGS ERROR 190 PROCESS ABENDING.

Cause

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
Cause
Solution


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