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