When Running the FTI Script to Move from 6.0 to 6.01 the Following Error is Seen: ORA-23401: materialized view "GLOGOWNER"."EXTERNAL_PREDICATE" does not exist

(Doc ID 856411.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.0.1 to 6.0.2 [Release 6]
Information in this document applies to any platform.
***Checked for relevance on 12-Apr-2013***


Symptoms

-- Problem Statement:

When running the FTI script exec dbms_mview.refresh('EXTERNAL_PREDICATE'); as part of the 6.0. to 6.0.1 upgrade patch, the following error is received:

SQL> exec dbms_mview.refresh('EXTERNAL_PREDICATE');
BEGIN dbms_mview.refresh('EXTERNAL_PREDICATE'); END;

*
ERROR at line 1:
ORA-23401: materialized view "GLOGOWNER"."EXTERNAL_PREDICATE" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2545
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2751
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2720
ORA-06512: at line 1

-- Steps To Reproduce:

1. Log into the database as glogowner using sqlplus to the FTI database.

2. Run the following command per the 6.0.1 instructions:

exec dbms_mview.refresh('EXTERNAL_PREDICATE');

3. Note the error above is displayed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms