My Oracle Support Banner

Materialized View creation over dblink fails with ORA-02069 when Global_names=TRUE (Doc ID 2469124.1)

Last updated on NOVEMBER 05, 2018

Applies to:

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

Symptoms

Materialized View creation over dblink fails with ORA-02069 when Global_names=TRUE

The issue is seen on 12.1.0.2.160719 or above when Global_names=TRUE

ORA-02069: global_names parameter must be set to TRUE for this operation
----- Current SQL Statement for this session (sql_id=9vm6n66pcvcpj) -----
select
case when col3 < sysdate-3 then 1
else
(select ndtestcase2.testcasepackage.f_basic_function@test_db_link(col1, col2, col3) from dual)
end col3, col1, col2
from ndtestcase1.test1

STACK:

skdstdst()+45 call kgdsdst() 7FFCF9B26A48 000000002
7FFCF9B08480 ? 7FFCF9B08598 ?
7FFCF9B26278 ? 000000082 ?
ksedst()+119 call skdstdst() 7FFCF9B26A48 000000000
000000001 7FFCF9B08598 ?
7FFCF9B26278 ? 000000082 ?
dbkedDefDump()+1119 call ksedst() 000000000 000000000 ?
000000001 ? 7FFCF9B08598 ?
7FFCF9B26278 ? 000000082 ?
ksedmp()+261 call dbkedDefDump() 000000003 000000000
000000001 ? 7FFCF9B08598 ?
7FFCF9B26278 ? 000000082 ?
dbkdaKsdActDriver() call ksedmp() 000000003 000000000 ?
+886 000000001 ? 000000000
7FFCF9B26278 ? 000000082 ?
dbgdaExecuteAction( call dbkdaKsdActDriver() 7F79AF50C648 7FFCF9B28EF0
)+358 000000001 ? 000000000 ?
7FFCF9B26278 ? 000000082 ?
dbgdaRunAction()+49 call dbgdaExecuteAction( 7F79AF50C648 00E4419A0
7 ) 000000000 7FFCF9B28EF0
000000001 000000082 ?
dbgdRunActions()+89 call dbgdaRunAction() 7F79AF50C648 7FFCF9B29160
000000000 000000000
7FFCF9B29180 000000082 ?
dbgdProcessEventAct call dbgdRunActions() 7F79AF50C648 ? 7FFCF9B29160 ?
ions()+228 000000000 ? 000000000 ?
7FFCF9B29180 ? 000000082 ?
dbgdChkEventKgErr() call dbgdProcessEventAct 7F79AF50C648 7F79AF54CCA0
+332 ions() 7F79AEBD8050 000000000 ?
7FFCF9B29180 ? 000000082 ?
dbkdChkEventRdbmsEr call dbgdChkEventKgErr() 7F79AF50C648 ? 7F79AF54CCA0 ?
r()+82 7F79AEBD8050 ? 000000000 ?
7FFCF9B29180 ? 000000082 ?
ksfpec()+85 call dbkdChkEventRdbmsEr 7F79AF50C648 ? 7F79AF54CCA0 ?
r() 7F79AEBD8050 ? 000000000 ?
7FFCF9B29180 ? 000000082 ?
dbgePostErrorKGE()+ call ksfpec() 7F79AF54CCA0 000000815
1063 7F79AEBD8050 ? 000000000 ?
7FFCF9B29180 ? 000000082 ?
dbkePostKGE_kgsf()+ call dbgePostErrorKGE() 7F79AF54CCA0 7F79AF060048
90 000000815 000000000 ?
7FFCF9B29180 ? 000000082 ?
kgeselv()+409 call dbkePostKGE_kgsf() 7F79AF54CCA0 7F79AF060048
000000815 000000000 ?
7FFCF9B29180 ? 000000082 ?
kgesecl0()+141 call kgeselv() 7F79AF54CCA0 ? 7F79AF060048 ?
000000815 ? 00EC2F8B4
00EC2F8A8 7FFC00000000
qcuErroer()+37 call kgesecl0() 7F79AF54CCA0 ? 7F79AF060048 ?
000000815 ? 00EC2F8B4 ?
00EC2F8A8 ? 065A7C230
erroer()+44 call qcuErroer() 7F79AF54CCA0 ? 7F79AF060048 ?
000000815 ? 00EC2F8B4 ?
00EC2F8A8 ? 065A7C230 ?
msqpfn()+830 call erroer() 000000815 7F79AF060048 ?
000000815 ? 00EC2F8B4 ?
00EC2F8A8 ? 065A7C230 ?
msqfun()+6088 call msqpfn() 7FFCF9B399D8 ? 7F79AEAB1080 ?
000000815 ? 00EC2F8B4 ?
00EC2F8A8 ? 065A7C230 ?
k2copnws()+279 call msqfun() 7FFCF9B399D8 ? 000000000
7F79AEB1DB40 ? 7F79AEB1EF68
000000000 065A7C230 ?
msqopnws()+447 call k2copnws() 7FFCF9B399D8 000000000
000000000 7F79AEB1EF68
000000000 ? 065A7C230 ?
msqsellst()+719 call msqopnws() 7FFCF9B399D8 000000000
7F79AEB1DB40 7F79AEB1EF68
000000000 065A7C230 ?
msqsel()+867 call msqsellst() 7FFCF9B399D8 ? 7F79AEB1EFF0
7F79AEAB2CE8 000000001
7FFCF9B2A488 7FFC00000000
msqsub()+230 call msqsel() 7FFCF9B399D8 7F79AEB1EFF0
7F79AEAB2CE8 ? 000000001 ?
7FFCF9B2A488 ? 7FFC00000000 ?
msqopnws()+12104 call msqsub() 7FFCF9B399D8 7F79AEB1EFF0
7F79AEAB2CE8 ? 000000000
7FFCF9B2A488 ? 7FFC00000000 ?
kokuoop()+426 call msqopnws() 7FFCF9B399D8 000000000
7F79AEB1D660 000000000
000000000 7FFC00000000 ?
k2copnws()+279 call kokuoop() 7FFC00000000 000000000
7F79AEB1D5B0 7F79AEAB2CA8
000000000 ? 7FFC00000000 ?
msqopnws()+447 call k2copnws() 7FFCF9B399D8 000000000
000000000 7F79AEAB2CA8
000000000 ? 7FFC00000000 ?
msqsellst()+719 call msqopnws() 7FFCF9B399D8 000000000
7F79AEB1D5B0 7F79AEAB2CA8
000000000 7FFC00000000 ?
msqsel()+867 call msqsellst() 7FFCF9B399D8 ? 7F79AEAB2CE8
7F79AEAB2CE8 000000001
7FFCF9B2AC58 7FFC00000800
kkzgiselalias()+303 call msqsel() 7FFCF9B399D8 7F79AEAB2CE8
7F79AEAB2CE8 ? 000000001 ?
7FFCF9B2AC58 ? 7FFC00000800 ?
kkzpcbk()+44 call kkzgiselalias() 065A7C518 7FFCF9B399D8
7F79AEAB2CE8 ? 000000001 ?
7FFCF9B2AC58 ? 7FFC00000800 ?
opiSem()+12941 call kkzpcbk() 065A7C518 7FFCF9B399D8 ?
7F79AEAB2CE8 ? 000000001 ?
7FFCF9B2AC58 ? 7FFC00000800 ?
opiprs()+319 call opiSem() 7FFCF9B35100 06590BB48
0000000BA 000000000
7FFCF9B2AC58 ? 7FFC00000800 ?
kksParseChildCursor call opiprs() 7F79AEB36000 06590BB48
()+544 0000000BA 065A7C518 000000000
000000002
rpiswu2()+1918 call kksParseChildCursor 7F79AEB36000 ? 06590BB48 ?
() 7F79AEB36000 7FFCF9B36240
000000000 ? 000000002 ?
kksLoadChild()+5200 call rpiswu2() 7F79AEB36000 ? 06590BB48 ?
7F79AEB36000 ? 000000068 ?
7F79AF54CCA0 ? 000000002 ?
kxsGetRuntimeLock() call kksLoadChild() 7F79AF54CCA0 06590BB48 ?
+2155 060AC45E0 000000068 ?
7F79AF54CCA0 ? 000000002 ?
kksfbc()+14431 call kxsGetRuntimeLock() 7F79AF54CCA0 7F79AEB36000
7FFCF9B365E0 060FCB748 ?
7F79AF54CCA0 ? 060FCB748
kkspsc0()+3124 call kksfbc() 7F79AEB36000 7F79AEB36000 ?
7FFCF9B365E0 ? 060FCB748 ?
7F79AF54CCA0 ? 060FCB748 ?
kksParseCursor()+11 call kkspsc0() 7F79AF0927B0 06590BB48
8 0000000BA 000000003
7F7900000002 000000010
opiosq0()+2215 call kksParseCursor() 7FFCF9B37438 ? 06590BB48 ?
0000000BA ? 000000003 ?
7F7900000002 ? 000000010 ?
opiall0()+7008 call opiosq0() 000000003 06590BB48 ?
7F79AF57E2A0 ? 000000010
000000000 000000010 ?
opikpr()+567 call opiall0() 000000003 ? 000000022
7FFCF9B38010 000000010 ?
000000000 ? 000000010 ?
opiodr()+1165 call opikpr() 000000065 ? 000000022 ?
7FFCF9B39558 000000010 ?
000000000 ? 000000010 ?
rpidrus()+206 call opiodr() 000000065 00000001F
7FFCF9B39558 ? 000000010 ?
000000000 ? 100000001
skgmstack()+144 call rpidrus() 7FFCF9B39130 00000001F ?
7F79AF54CE98 000000010 ?
000000000 ? 100000001 ?
rpiswu2()+772 call skgmstack() 7FFCF9B39108 ? 7F79AF54C7C0 ?
00000F618 ? 00CFC8720 ?
7FFCF9B39130 ? 100000001 ?
kprball()+1163 call rpiswu2() 7FFCF9B39108 ? 7F79AF54C7C0 ?
00000F618 ? 00000001A ?
7F79AF54CCA0 ? 100000001 ?
kprbprsu()+211 call kprball() 7FFCF9B39558 000040580
00000F618 ? 00000001A ?
7F79AF54CCA0 ? 100000001 ?
kkzparse()+1171 call kprbprsu() 7FFCF9B39558 ? 000040580 ?
00000F618 ? 00000001A ?
7F79AF54CCA0 ? 100000001 ?
kkzgcbdrv()+90 call kkzparse() 06590BB48 0000000B9 000000000
06591053C 000000001 006F2DF60
kkzgen()+5228 call kkzgcbdrv() 06590BB48 0000000B9 000000000
06591053C 000000001 006F2DF60
kkzcsn()+3832 call kkzgen() 06590BB48 0000000B9 000200144
06591053C 000000001 000400000
opiexe()+23689 call kkzcsn() 06590BB48 ? 0000000B9 ?
06591CF78 06591053C ?
000000001 ? 000400000 ?
opiosq0()+4531 call opiexe() 06590BB48 ? 0000000B9 ?
7FFCF9B3B7D0 06591053C ?
000000001 ? 000400000 ?
kpoal8()+1296 call opiosq0() 000000003 0000000B9 ?
7F79AF54CE98 ? 0000000A4
000000000 000400000 ?
opiodr()+1165 call kpoal8() 00000005E 00000001F
7FFCF9B3F6E8 0000000A4 ?
000000000 ? 000400000 ?
ttcpip()+2699 call opiodr() 00000005E 00000001F
7FFCF9B3F6E8 ? 0000000A4 ?
000000000 ? 100000000
opitsk()+1740 call ttcpip() 7F79AF562090 ? 00000005E ?
7FFCF9B3F6E8 000000000 ?
7FFCF9B3F148 7FFCF9B3F8FC
opiino()+945 call opitsk() 000000400 000000000
7FFCF9B3F6E8 ? 000000000 ?
7FFCF9B3F148 ? 7FFCF9B3F8FC ?
opiodr()+1165 call opiino() 00000003C 000000004
7FFCF9B40D98 000000000 ?
7FFCF9B3F148 ? 7FFCF9B3F8FC ?
opidrv()+587 call opiodr() 00000003C 000000004
7FFCF9B40D98 ? 000000000 ?
7FFCF9B3F148 ? 000000000
sou2o()+145 call opidrv() 00000003C 000000004
7FFCF9B40D98 000000000 ?
7FFCF9B3F148 ? 000000000 ?
opimai_real()+154 call sou2o() 7FFCF9B40D70 00000003C
000000004 7FFCF9B40D98
7FFCF9B3F148 ? 000000000 ?
ssthrdmain()+412 call opimai_real() 000000000 7FFCF9B41080
000000004 ? 7FFCF9



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.