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 NOVEMBER 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation 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 |