My Oracle Support Banner

Are Materialized Views Part of the Agile Product Lifecycle Management (PLM) Schema? (Doc ID 2756480.1)

Last updated on FEBRUARY 28, 2021

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Goal

We are in the process of lift and shift of current customer on-premises environments to OCI. While doing the migration for Agile PLM, we see that the import is getting stuck at the creation of materialized view logs. We divided the import into two parts, one with everything else except materialized view logs and one with just materialized view logs. The one with Agile schema completed, but materialized view logs keep running. When we checked further, we see no materialized views in the database, but see many logs. We need to understand what will cause this, as all materialized views logs seem to be standard, and they are not custom views.
 

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.