Tables Cannot Be Queried From Backend, But They Work Fine Via The User Interface (Doc ID 3024928.1)

Last updated on MAY 30, 2024

Applies to:

Oracle Life Sciences Data Management Workbench - Version 3.1.1 and later
Information in this document applies to any platform.

Symptoms

Some tables cannot be queried from backend, using SQL*Developer, or Toad. The same database objects are queried successfully via LSH/DMW User Interface. The following error is generated when attempting to access the tables from backend:

ERROR(S)
==========
ORA-00942 table or view does not exist

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.

Tables Cannot Be Queried From Backend, But They Work Fine Via The User Interface (Doc ID 3024928.1)

Applies to:

Symptoms

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!