My Oracle Support Banner

Dbms_mview.end_table_reorganization With Commit SCN-based Materialized View Logs Gives ORA-00904: "SNAPTIME$$": invalid identifier (Doc ID 1955438.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

dbms_mview.end_table_reorganization in combination with commit SCN-based materialized view logs reports the error below:


ORA-00904: "SNAPTIME$$": invalid identifier
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 756
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3085

 

----- Error Stack Dump -----
ORA-00904: "SNAPTIME$$": invalid identifier
----- Current SQL Statement for this session (sql_id=c5jhyr7aswr59) -----
UPDATE "SH"."MLOG$_A"   SET snaptime$$ = SYSDATE  WHERE snaptime$$ IS NULL OR snaptime$$ > :d1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x650ecdd0      1289  package body SYS.DBMS_SYS_SQL
0x63cafec0       720  package body SYS.DBMS_SNAP_INTERNAL
0x675c05d0      3085  package body SYS.DBMS_SNAPSHOT
0x67541350         1  anonymous block


----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------

*** 2014-12-17 12:36:16.784
skdstdst()+41        call     kgdsdst()            000000000 ? 000000000 ?
                                                  7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
ksedst1()+103        call     skdstdst()           000000000 ? 000000000 ?
                                                  7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
ksedst()+39          call     ksedst1()            000000000 ? 000000001 ?
                                                  7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
dbkedDefDump()+2746  call     ksedst()             000000000 ? 000000001 ?
                                                  7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
ksedmp()+41          call     dbkedDefDump()       000000003 ? 000000000 ?
                                                  7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
dbkdaKsdActDriver()  call     ksedmp()             000000003 ? 000000000 ?
+1960                                              7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
dbgdaExecuteAction(  call     dbkdaKsdActDriver()  2B3520CA8730 ? 7FFFEAAD9940 ?
)+1065                                             7FFFEAAD26C0 ? 7FFFEAAD2798 ?
                                                  7FFFEAAD7240 ? 000000002 ?
dbgdaRunAction()+81  call     dbgdaExecuteAction(  2B3520CA8730 ? 00A6154E0 ?
5                             )                    0020C0003 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
dbgdRunActions()+64  call     dbgdaRunAction()     2B3520CA8730 ? 000000005 ?
                                                  0020C0003 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
dbgdProcessEventAct  call     dbgdRunActions()     2B3520CA8730 ? 000000005 ?
ions()+656                                         0020C0003 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
dbgdChkEventKgErr()  call     dbgdProcessEventAct  2B3520CA8730 ? 00C0E3A40 ?
+1658                         ions()               2B35212B2578 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
dbkdChkEventRdbmsEr  call     dbgdChkEventKgErr()  2B3520CA8730 ? 00C0E3A40 ?
r()+61                                             2B35212B2578 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
ksfpec()+66          call     dbkdChkEventRdbmsEr  2B3520CA8730 ? 00C0E3A40 ?
                             r()                  2B35212B2578 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
dbgePostErrorKGE()+  call     ksfpec()             2B3520CA8730 ? 00C0E3A40 ?
1137                                               2B35212B2578 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
dbkePostKGE_kgsf()+  call     dbgePostErrorKGE()   00C0E3A40 ? 2B35210E23C8 ?
71                                                 000000388 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
kgesev()+280         call     dbkePostKGE_kgsf()   00C0E3A40 ? 2B35210E23C8 ?
                                                  000000388 ? 7FFFEAAD9940 ?
                                                  000000001 ? 000000002 ?
kgesec1()+140        call     kgesev()             00C0E3A40 ? 2B35210E23C8 ?
                                                  000000388 ? 000000001 ?
                                                  7FFFEAADA6E0 ? 000000002 ?
qcuErrGen()+116      call     kgesec1()            00C0E3A40 ? 2B35210E23C8 ?
                                                  000000388 ? 000000001 ?
                                                  00000000C ? 2B35210D7888 ?
qcsRslvName()+1270   call     qcuErrGen()          00C0E3A40 ? 2B35210E23C8 ?
                                                  2B35210E0180 ? 00000004E ?
                                                  00000000C ? 2B35210D7888 ?
qcsridn()+105        call     qcsRslvName()        7FFFEAADA890 ? 00C0E3A40 ?
                                                  7FFFEAADA810 ? 00000004E ?
                                                  00000000C ? 2B35210D7888 ?
qcsnrupd()+138       call     qcsridn()            07433EA08 ? 00C0E3A40 ?
                                                  7FFFEAADA810 ? 000000004 ? 

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.