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 MAY 06, 2022
Applies to:
Oracle Transportation Management - Version 6.0.1 to 6.0.2 [Release 6]Information in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |