My Oracle Support Banner

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 JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.0.1 to 6.0.2 [Release 6]
Information in this document applies to any platform.


-- 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.


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.