My Oracle Support Banner

Browse Data for a Create a Table as a View Fails with Error after Remote Location Connection Details are Changed (Doc ID 2686147.1)

Last updated on JULY 02, 2020

Applies to:

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


On Oracle Life Sciences Data Hub (LSH) version,

Remote Location connection settings were changed as part of a migration activity.

When attempting to browse data in a Table Instance of type 'Create a Table as a View',
the following error occurs:


The issue can be reproduced with the following steps:
1. Migrate the environment to a new location.
2. Update the Remote Locations with the new connection details.
3. Attempt to browse existing tables data or to install the Work Areas including the table using the Oracle Tables and Views Remote Locations.


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.