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 DECEMBER 18, 2014

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

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