My Oracle Support Banner

Is it Possible to Refresh the Schema Every Time the Externally Linked View (the Database View Outside of WCC) Changes? (Doc ID 1598454.1)

Last updated on SEPTEMBER 05, 2018

Applies to:

Oracle WebCenter Content - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

We've configured some WCC/UCM views that are linked to Database synonym directly. This synonym is a dblink to another instance and it is filled by an external group. It works and metadata associated to this views works without issue.

But our problem is that when a external user populates the Database synonym, the changes in the view are not refreshing automatically in WCC/UCM instance. We have to manually refresh the UCM schema from WCC/UCM admin menu (Configuration Manager).

Is there any workaround or configuration setting that could refresh the schema every time the external view (database view outside WCC) changes?
 

Solution

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


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