用户可正常执行dblink查询语句(该dblink为私有 对应的用户为busi,具备ceate any view权限),但是在执行create view xxx as select * from xx@tstacct;时报出ORA-02019: connection description for remote database not found ,
10046事件信息如下:
/ora10g/admin/crmcl/udump/crmcl1_ora_266642_ybb.trc
*** TRACE DUMP CONTINUED FROM FILE /ora10g/admin/crmcl/udump/crmcl1_ora_266642.trc ***
EXEC #1:c=0,e=6238,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=26738351357944
WAIT #1: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738351357967
WAIT #1: nam='SQL*Net message from client' ela= 7304565 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738358662556
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #2 len=85 dep=0 uid=35 oct=21 lid=35 tim=26738358662967 hv=0 ad='1048fc08'
create view acct.charge_item_due_201905 as select * from acct.charge_item_due@tstacct
END OF STMT
PARSE #2:c=0,e=330,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=26738358662964
BINDS #2:
EXEC #2:c=0,e=234,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=1,tim=26738358663237
ERROR #2:err=2019 tim=1231442558
WAIT #2: nam='log file sync' ela= 67893 buffer#=193 p2=1846586545 p3=0 obj#=-1 tim=26738358731221
WAIT #2: nam='SQL*Net break/reset to client' ela= 1 driver id=1650815232 break?=1 p3=0 obj#=-1 tim=26738358731247
WAIT #2: nam='SQL*Net break/reset to client' ela= 43 driver id=1650815232 break?=0 p3=0 obj#=-1 tim=26738358731300
WAIT #2: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738358731314
*** 2019-05-22 13:24:20.312
WAIT #2: nam='SQL*Net message from client' ela= 7909359 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=26738366640701
PARSE #1:c=0,e=10,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=26738366640778
EXEC #1:c=0,e=52,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=26738366640845
墨值悬赏

评论
