BEGIN dbms_refresh.refresh('"HW"."G101"'); END;
SELECT USER FROM SYS.DUAL
SELECT NAME FROM USER$ WHERE NAME = :b1
SELECT R.REFGROUP FROM SYS.RGROUP$ R WHERE R.OWNER = :b1 AND R.NAME = :b2 AND R.INSTSITE = :b3 FOR UPDATE
SELECT NAME FROM SYS.USER$ WHERE USER# = :b1
SELECT OWNER FROM SYS.RGROUP$ WHERE REFGROUP = :b1 FOR UPDATE
SELECT C.OWNER,C.NAME FROM SYS.RGCHILD$ C WHERE C.REFGROUP = :b1
SELECT ROLLBACK_SEG,FLAG,JOB,PURGE_OPT#,PARALLELISM#,HEAP_SIZE# FROM SYS.RGROUP$ WHERE REFGROUP = :b1
SELECT 1 FROM SYS.SNAP$ WHERE SOWNER = :b1 AND VNAME = :b2 AND INSTSITE = 0
SELECT SUBSTR(MLINK,2),TNAME,USLOG,SUBSTR(AUTO_FAST,1,1),BITAND(FLAG,:b1)
FROM
SYS.SNAP$ WHERE SOWNER = :b2 AND VNAME = :b3 AND INSTSITE = 0
select value$
from
props$ where name = 'GLOBAL_DB_NAME'
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,
o.dataobj#,o.flags
from
obj$ o where o.obj#=:1
SELECT LOCKID
FROM
DBMS_LOCK_ALLOCATED WHERE NAME = :b1 FOR UPDATE
UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION=SYSDATE + (:b1 / 86400 )
WHERE
ROWID = :b2
SELECT NVL(DISABLED,'F'),FLAG
FROM
SYSTEM.DEF$_DESTINATION WHERE DBLINK = NLS_UPPER(:b1) AND CATCHUP = :b2
select last_delivered, last_enq_tid, last_seq, disabled, rowid,
decode(apply_init, NULL, 1, 0), NVL(flag, '00000000')
from
system.def$_destination where dblink = :1 and catchup = :2
update system.def$_destination set last_delivered = :1, last_enq_tid =
:2, last_seq = :3, last_txn_count = :4, total_txn_count =
total_txn_count + :5, total_prop_time_throughput =
total_prop_time_throughput + :6, total_prop_time_latency =
total_prop_time_latency + :7, to_communication_size =
to_communication_size + :8, from_communication_size =
from_communication_size + :9, spare1 = spare1 + :10, spare2 = spare2 +
:11, spare3 = spare3 + :12, spare4 = spare4 + :13, last_error_number =
:14, last_error_message = :15
where
rowid = :16
select disabled, NVL(flag, '00000000')
from
system.def$_destination where rowid = :1
select last_delivered, last_enq_tid, rowid
from
system.def$_destination dd where (dd.dblink != :1) and ( exists (
select 1 from system.def$_calldest cd where cd.dblink = dd.dblink
and cd.catchup = dd.catchup) or exists ( select 1 from
system.repcat$_repprop rp where rp.dblink = dd.dblink and rp.how = 1
and rp.extension_id = dd.catchup))
select last_delivered, last_enq_tid
from
system.def$_destination
select enq_tid
from
system.def$_aqcall where (cscn < :1)
delete from system.def$_lob
where
(enq_tid = :1)
delete from system.def$_calldest
where
(enq_tid = :1)
delete from system.def$_aqcall
where
(enq_tid = :1)
update system.def$_destination set last_delivered = :1, last_enq_tid =
:2, last_seq = :3, last_txn_count = :4, total_txn_count =
total_txn_count + :5, total_prop_time_throughput =
total_prop_time_throughput + :6, total_prop_time_latency =
total_prop_time_latency + :7, to_communication_size =
to_communication_size + :8, from_communication_size =
from_communication_size + :9, spare1 = spare1 + :10, spare2 = spare2 +
:11, spare3 = spare3 + :12, spare4 = spare4 + :13
where
rowid = :14
select user#
from
sys.user$ where name = 'OUTLN'
SET CONSTRAINTS ALL DEFERRED
SELECT '"' || CON$.NAME || '"'
FROM
CON$,USER$,CDEF$,OBJ$ WHERE USER$.NAME = :b1 AND OBJ$.NAME = :b2 AND
OBJ$.OWNER# = USER$.USER# AND OBJ$.NAMESPACE = 1 AND CDEF$.OBJ# =
OBJ$.OBJ# AND CDEF$.TYPE# = 2 AND BITAND(CDEF$.DEFER,1) = 1 AND
CON$.CON# = CDEF$.CON#
SELECT tname, snapid, flag, flag2, status, master_version, tables,
lobmaskvec, query_len, mas_roll_seg, mlink, snapshot, auto_fun,
uslog, NVL(rscn, 0), refhnt, objflag, auto_fast,
sna_type_oid, sna_type_hashcode, sna_type_owner, sna_type_name,
mas_type_oid, mas_type_hashcode, mas_type_owner, mas_type_name
FROM
sys.snap$ WHERE sowner = :1 and vname = :2 and instsite = :3
SELECT masobj#, masflag, mowner, master, lastsuccess, snaptime, sysdate,
loadertime, sysdate, NVL(refscn, 0), fcmaskvec, ejmaskvec,
sub_handle, change_view
FROM
sys.snap_reftime$ WHERE sowner = :1 AND vname = :2 AND instsite = :3 ORDER
BY tablenum
select sysdate + 100000/86400
from
dual
update sys.sumpartlog$ s set s.timestamp = :1, s.scn = :2
where
s.bo# = :3 and s.timestamp >= to_date('4000-01-01:00:00:00',
'YYYY-MM-DD:HH24:MI:SS')
begin sys.dbms_snapshot_utl.set_up@CCC.US.ORACLE.COM (:mown_col, :mas_col,
:rollseg_col, :flag_col, :outflag_col, :snaptime_col, :loadertime_col,
:num_sid, :snapid_tab, :max_tab_scn_col, :max_dl_scn_col,
:max_pmop_scn_col, :trunc_scn_col, :max_ins_tim_col, :max_upd_tim_col,
:max_del_tim_col, :max_ins_scn_col, :max_upd_scn_col, :max_del_scn_col,
:hdl_col, :hdl_indx_col, :rscn); end;
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1,
spare2
from
obj$ where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or
remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and
:5 is null)and(subname=:6 or subname is null and :6 is null)
insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,
remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2)
values
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16, :17)
select snacol, mascol, maspos, colrole, snapos
from
sys.snap_colmap$ WHERE sowner = :1 AND vname = :2 AND tabnum = :3 AND
instsite = :4
begin sys.dbms_snapshot_utl.verify_log@CCC.US.ORACLE.COM (:mown_col,
:mas_col, :masobj_col, :flag_col, :outflag_col, :lognm_col, :oldest_col,
:oldestpk_col, :oldloader_col, :oldest_oid_col, :oldestnew_col,
:fcvec_col, :youngest_fc_col, :hdl_col, :hdl_indx_col, :lrscn_col,
:stat_col, :typ_own_col, :typ_nam_col, :toid_col, :hashcode_col); end;
update sys.snap$ set snapshot = :1, snaptime = :2, auto_date = :3, snapid =
:4, error# = 0
where
vname = :6 and sowner = :5 and instsite = :7
select 1
from
sumpartlog$ a where a.bo# = :1 and bitand(a.flags,5) != 5 and rownum = 1
update sum$ set containerobj#=:2,containertype=:3,containernam=:4,
fullrefreshtim=:5,increfreshtim=:6,lastrefreshscn=:7,lastrefreshdate=:8,
refreshmode=:9,pflags=:10,mflags=:11,numdetailtab=:12,numaggregates=:13,
numkeycolumns=:14,numjoins=:15,numinlines=:16,sumtextlen=:17,sumtext=:18,
fromoffset=:19,fromlen=:20,objcount=:21,metaversion=:22, xpflags=:23,
numwhrnodes=:24, numhavnodes=:25where obj#=:1
SELECT operation#, cols, sql_txt, tabnum, fcmaskvec, ejmaskvec, setnum
FROM
sys.snap_refop$ WHERE ((operation# >= 0 AND operation# <= 6) OR operation#
= 10) AND sowner = :1 AND vname = :2 AND instsite = :3 ORDER BY tabnum,
setnum, operation#
UPDATE sys.snap$ SET status = :1, rscn = :2, refhnt = :3, flag = :4
WHERE
vname = :5 AND sowner = :6 AND instsite = :7
UPDATE sys.snap_reftime$ SET snaptime = :1, loadertime = :2, refscn = :3,
fcmaskvec = :4, ejmaskvec = :5, masobj# = :6, sub_handle = :7,
change_view = :8
WHERE
sowner = :9 AND vname = :10 AND tablenum = :11 AND instsite = :12
select count(*), max(scn)
from
sumdelta$, sumdep$ where sumobj# = :1 and p_obj# = tableobj# and scn > :2
select count(*), max(scn)
from
(select sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags from sumpartlog$ sp,
sumdep$ sd where sd.sumobj# = :1 and sd.p_obj# = sp.bo# group by
sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags minus select sp.BO#,
sp.PMOPTYPE, sp.scn, sp.flags from sumpartlog$ sp where sp.bo# not in
(select sk.DETAILOBJ# from sumkey$ sk where
sk.sumobj# = :1 and sk.DETAILCOLFUNCTION in (2,3) ) and
bitand(sp.flags, 2) != 2 and sp.PMOPTYPE in (2,3,5,7) group by
sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags) where scn > : 2
update sumdetail$ set detailobjtype=:3, detailalias=:4, refreshscn=:5,
detaileut=:6, spare4=:7, inline# =:8, dataless =:10
where
sumobj#=:1 and detailobj#=:2 and instance# =:9
select min(s1.lastrefreshscn)
from
sum$ s1, sumdetail$ s2 where s1.obj#= s2.sumobj# and s2.detailobj# = :1 and
s1.obj#!= :2
delete from sumpartlog$
where
bo#=:1 and scn<:2
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."PHONENUMBER"
FROM
(SELECT MLOG$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."MLOG$_T_USERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1 AND
("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."PHONENUMBER") NOT IN (SELECT
MAS_TAB$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."T_USERINFO"@CCC.US.ORACLE.COM "MAS_TAB$" WHERE LOG$."PHONENUMBER" =
MAS_TAB$."PHONENUMBER")
DELETE FROM "HW"."T_USERINFO_MV" SNAP$
WHERE
"PHONENUMBER" = :1
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."PHONENUMBER",
CURRENT$."PASSWD",CURRENT$."USERNAME",CURRENT$."IDCARD",
CURRENT$."USEREMAIL",CURRENT$."LOCALID",CURRENT$."BRANDID",
CURRENT$."PAYKIND",CURRENT$."MOBILETYPE",CURRENT$."HASOPENEMS",
CURRENT$."HASOPENMMS",CURRENT$."ISARREAR"
FROM
(SELECT "T_USERINFO"."PHONENUMBER" "PHONENUMBER","T_USERINFO"."PASSWD"
"PASSWD","T_USERINFO"."USERNAME" "USERNAME","T_USERINFO"."IDCARD" "IDCARD",
"T_USERINFO"."USEREMAIL" "USEREMAIL","T_USERINFO"."LOCALID" "LOCALID",
"T_USERINFO"."BRANDID" "BRANDID","T_USERINFO"."PAYKIND" "PAYKIND",
"T_USERINFO"."MOBILETYPE" "MOBILETYPE","T_USERINFO"."HASOPENEMS"
"HASOPENEMS","T_USERINFO"."HASOPENMMS" "HASOPENMMS","T_USERINFO"."ISARREAR"
"ISARREAR" FROM "HW"."T_USERINFO"@CCC.US.ORACLE.COM "T_USERINFO") CURRENT$,
(SELECT DISTINCT MLOG$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."MLOG$_T_USERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1 AND
("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."PHONENUMBER" =
LOG$."PHONENUMBER"
UPDATE "HW"."T_USERINFO_MV" SET "PHONENUMBER" = :1,"PASSWD" = :2,"USERNAME" =
:3,"IDCARD" = :4,"USEREMAIL" = :5,"LOCALID" = :6,"BRANDID" = :7,"PAYKIND" =
:8,"MOBILETYPE" = :9,"HASOPENEMS" = :10,"HASOPENMMS" = :11,"ISARREAR" = :12
WHERE
"PHONENUMBER" = :1
INSERT INTO "HW"."T_USERINFO_MV" ("PHONENUMBER","PASSWD","USERNAME","IDCARD",
"USEREMAIL","LOCALID","BRANDID","PAYKIND","MOBILETYPE","HASOPENEMS",
"HASOPENMMS","ISARREAR")
VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."MEMBERNUMBER" ,
LOG$."PHONENUMBER"
FROM
(SELECT MLOG$."MEMBERNUMBER" "MEMBERNUMBER" , MLOG$."PHONENUMBER"
"PHONENUMBER" FROM "HW"."MLOG$_T_MEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE
"SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."MEMBERNUMBER"
, LOG$."PHONENUMBER") NOT IN (SELECT MAS_TAB$."MEMBERNUMBER" "MEMBERNUMBER"
, MAS_TAB$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."T_MEMBERINFO"@CCC.US.ORACLE.COM "MAS_TAB$" WHERE LOG$."MEMBERNUMBER" =
MAS_TAB$."MEMBERNUMBER" AND LOG$."PHONENUMBER" = MAS_TAB$."PHONENUMBER")
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."MEMBERID",
CURRENT$."PHONENUMBER",CURRENT$."MEMBERNUMBER",CURRENT$."MEMBERNAME",
CURRENT$."MEMBERDETAILS"
FROM
(SELECT "T_MEMBERINFO"."MEMBERID" "MEMBERID","T_MEMBERINFO"."PHONENUMBER"
"PHONENUMBER","T_MEMBERINFO"."MEMBERNUMBER" "MEMBERNUMBER",
"T_MEMBERINFO"."MEMBERNAME" "MEMBERNAME","T_MEMBERINFO"."MEMBERDETAILS"
"MEMBERDETAILS" FROM "HW"."T_MEMBERINFO"@CCC.US.ORACLE.COM "T_MEMBERINFO")
CURRENT$, (SELECT DISTINCT MLOG$."MEMBERNUMBER" "MEMBERNUMBER" ,
MLOG$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."MLOG$_T_MEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."MEMBERNUMBER" =
LOG$."MEMBERNUMBER" AND CURRENT$."PHONENUMBER" = LOG$."PHONENUMBER"
INSERT INTO "HW"."T_MEMBERINFO_MV" ("MEMBERID","PHONENUMBER","MEMBERNUMBER",
"MEMBERNAME","MEMBERDETAILS")
VALUES
(:1,:2,:3,:4,:5)
UPDATE "HW"."T_MEMBERINFO_MV" SET "MEMBERID" = :1,"PHONENUMBER" = :2,
"MEMBERNUMBER" = :3,"MEMBERNAME" = :4,"MEMBERDETAILS" = :5
WHERE
"MEMBERNUMBER" = :3 AND "PHONENUMBER" = :2
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."USERSETID"
FROM
(SELECT MLOG$."USERSETID" "USERSETID" FROM
"HW"."MLOG$_T_CUSTOMIZE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."USERSETID") NOT IN (SELECT
MAS_TAB$."USERSETID" "USERSETID" FROM "HW"."T_CUSTOMIZE"@CCC.US.ORACLE.COM
"MAS_TAB$" WHERE LOG$."USERSETID" = MAS_TAB$."USERSETID")
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."USERSETID",
CURRENT$."PHONENUMBER",CURRENT$."SERVICETYPE",CURRENT$."SPECIALPHONE",
CURRENT$."SETTYPE",CURRENT$."BEGINTIME",CURRENT$."ENDTIME",
CURRENT$."PHONESTATE",CURRENT$."TIMETYPE",CURRENT$."LOOPTYPE",
CURRENT$."RESOURCETYPE",CURRENT$."TONEGROUPID",CURRENT$."LOOPNO",
CURRENT$."SETTIME",CURRENT$."STATUS",CURRENT$."DESCRIPTION"
FROM
(SELECT "T_CUSTOMIZE"."USERSETID" "USERSETID","T_CUSTOMIZE"."PHONENUMBER"
"PHONENUMBER","T_CUSTOMIZE"."SERVICETYPE" "SERVICETYPE",
"T_CUSTOMIZE"."SPECIALPHONE" "SPECIALPHONE","T_CUSTOMIZE"."SETTYPE"
"SETTYPE","T_CUSTOMIZE"."BEGINTIME" "BEGINTIME","T_CUSTOMIZE"."ENDTIME"
"ENDTIME","T_CUSTOMIZE"."PHONESTATE" "PHONESTATE","T_CUSTOMIZE"."TIMETYPE"
"TIMETYPE","T_CUSTOMIZE"."LOOPTYPE" "LOOPTYPE","T_CUSTOMIZE"."RESOURCETYPE"
"RESOURCETYPE","T_CUSTOMIZE"."TONEGROUPID" "TONEGROUPID",
"T_CUSTOMIZE"."LOOPNO" "LOOPNO","T_CUSTOMIZE"."SETTIME" "SETTIME",
"T_CUSTOMIZE"."STATUS" "STATUS","T_CUSTOMIZE"."DESCRIPTION" "DESCRIPTION"
FROM "HW"."T_CUSTOMIZE"@CCC.US.ORACLE.COM "T_CUSTOMIZE") CURRENT$, (SELECT
DISTINCT MLOG$."USERSETID" "USERSETID" FROM
"HW"."MLOG$_T_CUSTOMIZE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."USERSETID" =
LOG$."USERSETID"
INSERT INTO "HW"."T_CUSTOMIZE_MV" ("USERSETID","PHONENUMBER","SERVICETYPE",
"SPECIALPHONE","SETTYPE","BEGINTIME","ENDTIME","PHONESTATE","TIMETYPE",
"LOOPTYPE","RESOURCETYPE","TONEGROUPID","LOOPNO","SETTIME","STATUS",
"DESCRIPTION")
VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16)
UPDATE "HW"."T_CUSTOMIZE_MV" SET "USERSETID" = :1,"PHONENUMBER" = :2,
"SERVICETYPE" = :3,"SPECIALPHONE" = :4,"SETTYPE" = :5,"BEGINTIME" = :6,
"ENDTIME" = :7,"PHONESTATE" = :8,"TIMETYPE" = :9,"LOOPTYPE" = :10,
"RESOURCETYPE" = :11,"TONEGROUPID" = :12,"LOOPNO" = :13,"SETTIME" = :14,
"STATUS" = :15,"DESCRIPTION" = :16
WHERE
"USERSETID" = :1
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."GROUPID" ,
LOG$."PHONENUMBER"
FROM
(SELECT MLOG$."GROUPID" "GROUPID" , MLOG$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."MLOG$_T_GROUPINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1
AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."GROUPID" , LOG$."PHONENUMBER")
NOT IN (SELECT MAS_TAB$."GROUPID" "GROUPID" , MAS_TAB$."PHONENUMBER"
"PHONENUMBER" FROM "HW"."T_GROUPINFO"@CCC.US.ORACLE.COM "MAS_TAB$" WHERE
LOG$."GROUPID" = MAS_TAB$."GROUPID" AND LOG$."PHONENUMBER" =
MAS_TAB$."PHONENUMBER")
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."USERGROUPID",
CURRENT$."PHONENUMBER",CURRENT$."GROUPID",CURRENT$."GROUPNAME",
CURRENT$."DESCRIPTION"
FROM
(SELECT "T_GROUPINFO"."USERGROUPID" "USERGROUPID",
"T_GROUPINFO"."PHONENUMBER" "PHONENUMBER","T_GROUPINFO"."GROUPID" "GROUPID",
"T_GROUPINFO"."GROUPNAME" "GROUPNAME","T_GROUPINFO"."DESCRIPTION"
"DESCRIPTION" FROM "HW"."T_GROUPINFO"@CCC.US.ORACLE.COM "T_GROUPINFO")
CURRENT$, (SELECT DISTINCT MLOG$."GROUPID" "GROUPID" , MLOG$."PHONENUMBER"
"PHONENUMBER" FROM "HW"."MLOG$_T_GROUPINFO"@CCC.US.ORACLE.COM MLOG$ WHERE
"SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."GROUPID" =
LOG$."GROUPID" AND CURRENT$."PHONENUMBER" = LOG$."PHONENUMBER"
INSERT INTO "HW"."T_GROUPINFO_MV" ("USERGROUPID","PHONENUMBER","GROUPID",
"GROUPNAME","DESCRIPTION")
VALUES
(:1,:2,:3,:4,:5)
UPDATE "HW"."T_GROUPINFO_MV" SET "USERGROUPID" = :1,"PHONENUMBER" = :2,
"GROUPID" = :3,"GROUPNAME" = :4,"DESCRIPTION" = :5
WHERE
"GROUPID" = :3 AND "PHONENUMBER" = :2
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."GROUPID" ,
LOG$."MEMBERNUMBER" , LOG$."PHONENUMBER"
FROM
(SELECT MLOG$."GROUPID" "GROUPID" , MLOG$."MEMBERNUMBER" "MEMBERNUMBER" ,
MLOG$."PHONENUMBER" "PHONENUMBER" FROM
"HW"."MLOG$_T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" >
:1 AND ("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."GROUPID" ,
LOG$."MEMBERNUMBER" , LOG$."PHONENUMBER") NOT IN (SELECT MAS_TAB$."GROUPID"
"GROUPID" , MAS_TAB$."MEMBERNUMBER" "MEMBERNUMBER" , MAS_TAB$."PHONENUMBER"
"PHONENUMBER" FROM "HW"."T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM "MAS_TAB$"
WHERE LOG$."GROUPID" = MAS_TAB$."GROUPID" AND LOG$."MEMBERNUMBER" =
MAS_TAB$."MEMBERNUMBER" AND LOG$."PHONENUMBER" = MAS_TAB$."PHONENUMBER")
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."GROUPMEMBERID",
CURRENT$."PHONENUMBER",CURRENT$."GROUPID",CURRENT$."MEMBERNUMBER"
FROM
(SELECT "T_GROUPMEMBERINFO"."GROUPMEMBERID" "GROUPMEMBERID",
"T_GROUPMEMBERINFO"."PHONENUMBER" "PHONENUMBER",
"T_GROUPMEMBERINFO"."GROUPID" "GROUPID","T_GROUPMEMBERINFO"."MEMBERNUMBER"
"MEMBERNUMBER" FROM "HW"."T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM
"T_GROUPMEMBERINFO") CURRENT$, (SELECT DISTINCT MLOG$."GROUPID" "GROUPID" ,
MLOG$."MEMBERNUMBER" "MEMBERNUMBER" , MLOG$."PHONENUMBER" "PHONENUMBER"
FROM "HW"."MLOG$_T_GROUPMEMBERINFO"@CCC.US.ORACLE.COM MLOG$ WHERE
"SNAPTIME$$" > :1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."GROUPID" =
LOG$."GROUPID" AND CURRENT$."MEMBERNUMBER" = LOG$."MEMBERNUMBER" AND
CURRENT$."PHONENUMBER" = LOG$."PHONENUMBER"
INSERT INTO "HW"."T_GROUPMEMBERINFO_MV" ("GROUPMEMBERID","PHONENUMBER",
"GROUPID","MEMBERNUMBER")
VALUES
(:1,:2,:3,:4)
UPDATE "HW"."T_GROUPMEMBERINFO_MV" SET "GROUPMEMBERID" = :1,"PHONENUMBER" =
:2,"GROUPID" = :3,"MEMBERNUMBER" = :4
WHERE
"GROUPID" = :3 AND "MEMBERNUMBER" = :4 AND "PHONENUMBER" = :2
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ DISTINCT LOG$."LOOPTONEID"
FROM
(SELECT MLOG$."LOOPTONEID" "LOOPTONEID" FROM
"HW"."MLOG$_T_LOOPTONE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" > :1 AND
("DMLTYPE$$" != 'I')) LOG$ WHERE (LOG$."LOOPTONEID") NOT IN (SELECT
MAS_TAB$."LOOPTONEID" "LOOPTONEID" FROM "HW"."T_LOOPTONE"@CCC.US.ORACLE.COM
"MAS_TAB$" WHERE LOG$."LOOPTONEID" = MAS_TAB$."LOOPTONEID")
SELECT /*+ remote_mapped(CCC.US.ORACLE.COM) */ CURRENT$."LOOPTONEID",
CURRENT$."PHONENUMBER",CURRENT$."TONEGROUPID",CURRENT$."TONEID",
CURRENT$."OFFSET",CURRENT$."LOOPNO"
FROM
(SELECT "T_LOOPTONE"."LOOPTONEID" "LOOPTONEID","T_LOOPTONE"."PHONENUMBER"
"PHONENUMBER","T_LOOPTONE"."TONEGROUPID" "TONEGROUPID",
"T_LOOPTONE"."TONEID" "TONEID","T_LOOPTONE"."OFFSET" "OFFSET",
"T_LOOPTONE"."LOOPNO" "LOOPNO" FROM "HW"."T_LOOPTONE"@CCC.US.ORACLE.COM
"T_LOOPTONE") CURRENT$, (SELECT DISTINCT MLOG$."LOOPTONEID" "LOOPTONEID"
FROM "HW"."MLOG$_T_LOOPTONE"@CCC.US.ORACLE.COM MLOG$ WHERE "SNAPTIME$$" >
:1 AND ("DMLTYPE$$" != 'D')) LOG$ WHERE CURRENT$."LOOPTONEID" =
LOG$."LOOPTONEID"
INSERT INTO "HW"."T_LOOPTONE_MV" ("LOOPTONEID","PHONENUMBER","TONEGROUPID",
"TONEID","OFFSET","LOOPNO")
VALUES
(:1,:2,:3,:4,:5,:6)
UPDATE "HW"."T_LOOPTONE_MV" SET "LOOPTONEID" = :1,"PHONENUMBER" = :2,
"TONEGROUPID" = :3,"TONEID" = :4,"OFFSET" = :5,"LOOPNO" = :6
WHERE
"LOOPTONEID" = :1
begin sys.dbms_snapshot_utl.wrap_up@CCC.US.ORACLE.COM (:mow_col, :mas_col,
:masobj_col, :rollseg_col, :flag_col, :snaptime_col, :loadertime_col,
:snapid_col, :snaptype_col, :masindx_col); end;
SELECT FLAG
FROM
SYS.JOB$ WHERE JOB = :b1
UPDATE SYS.JOB$ J SET FLAG=:b1,NEXT_DATE=NVL(:b2,J.NEXT_DATE)
WHERE
JOB = :b3
BEGIN dbms_support.stop_trace; END;
SELECT SID
FROM
V$MYSTAT WHERE ROWNUM = 1
SELECT SERIAL#
FROM
V$SESSION WHERE SID = :b1
SELECT STATUS
FROM
V$SESSION WHERE SID = :b1 AND SERIAL# = :b2