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 slow =: b1 and vName =: b2 andient = 0
Select Substr (Mlink, 2), TName, USLog, Substr (Auto_fast, 1, 1), Bitand (Flag,: B1) from sys.snap $ Where software =: b2 and vName =: b3 andient = 0
SELECT VALUE $ from Props $ Where name = 'global_db_name'
Select O. Wener #, O.Name, O.Namespace, O.Remoteowner, O.LinkName, O.Subname, O.DataObj #, O.Flags from Obj $ o Where obj # =: 1
SELECT LOCKID from DBMS_LOCK_ALLOCATED Where name =: b1 for update
Update dbms_lock_allocated set expression = 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, DISABED, 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 =: 16select 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 =: 14select user # from sys.user $ where name = 'outln'
SET Constraints All DefergeRed
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 instages =: 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 Tablenumselect 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-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01-01), '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_ins_scn_col,: max_upd_scn_col,: max_del_scn_col,: hdl_col,: hdl_indx_col,: rc); end;
Select Obj #, CTIME, Mtime, Stime, Status, DataObj #, Flags, Oid $, Spare1, Spare2 from Oid $ Where Owner # =: 1 and name =: 2 and name =: 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 software =: 1 and vName =: 2 and tabnum =: 3 andient =: 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 slow =: 5 and instages =: 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 slow =: 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 slowNer =: 6 andient =: 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 software =: 9 and vName =: 10 and Tablenum =: 11 and instsite =: 12select 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.sumj # =: 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, detailaload =: 4, refreshscn =: 5, detaileut =: 6, spare4 =: 7, inline # =: 8, DataSs =: 10 Where sumoBJ # =: 1 and detailobj # =: 2 and instance # =: 9
Select Min (S1.lastrefreshscn) from Sum $ S1, SUMDETAIL $ S2 Where S1.Obj # = S2.SUMOBJ # =: 1 and s1.obj # =: 2
Delete from sumpartlog $ where bo # =: 1 And SCN <: 2
SELECT / * Remote_mapped (ccc.us.racle.com) * / Distinct log $. "Phonenumber" from (select mlog $ "" Phonenumber "" 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.racle.com" mas_tab $ "WHERE log $." Phonenumber "= mas_tab $." Phonenumber ") delete from" hw "." T_userinfo_mv "Snap $ Where" Phonenumber "=: 1
SELECT / * Remote_mapped (ccc.us.racle.com) * / Current $. "Phonenumber", current $. "Passwd", current $. "Username", current $. "IDCARD", Current $. "UseMail" , Current $. "Localid", Current $. "BRANDID", Current $. "Paykind", Current $. "Mobilety", 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 ". "Useeremail" "useMail", "t_userinfo". "Localid" "localid", "t_userinfo". "BrandID" "BRANDID", "T_UserInfo", "T_USERINFO", "MobileType". "MobileType". "T_userinfo". "Hasopenems" "Hasopenems", "T_UserInfo". "Hasopenmms" "Hasopenmms", "t_userinfo". "Isarrear" "isarrear" from "hw". "Hw". "T_USERINFO" @ ccc.us.oracle.com " T_UserInfo ") Current $, (Select Distinct Mlog $." Phonenumber "" Phonenumber "from" hw "." Mlog $ _T_USERINFO "@ ccc.us.racle.com mlog $ Where" snaptime $$ ">: 1 and (" DMLTYPE $$ "! = 'D')) LOG $ Where current $." Phone Number "= log $." Phonenumber "
Update "HW". "T_userinfo_mv" set "phonenumber" =: 1, "passwd" =: 2, "username" =: 3, "idcard" =: 4, "useMail" =: 5, "localid" =: 6 "BrandID" =: 7, "paykind" =: 8, "mobileType" =: 9, "Hasopenems" =: 10, "Hasopenmms" =: 11, "isarrear" =: 12 WHERE "phonenumber" =: 1insert Into "HW". "T_USERINFO_MV" ("Phonenumber", "Passwd", "Username", "Idcard", "Brandid", "PAYKIND", "MobileType", "HasopenMMS", "Hasopenmms" "," Isarrear ") Values (: 1,: 2,: 3,: 4,: 5,: 6,: 7,: 8,: 9,: 10,: 11,: 12)
SELECT / * Remote_mapped (ccc.us.racle.com) * / Distinct log $. "MEMBERNUMBER", log $. "Phonenumber" from (SELECT MLOG $. "" MEMBERNUMBER ", mlog $." Phonenumber "" "From" hw "." Mlog $ _t_memberinfo "@ ccc.us.racle.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 "MAS_TAB $" WHERE log $. "MEMBERNUMBER" = MAS_TAB $. "MEMBERNUMBER" and log $. "Phonenumber" = mas_tab $. "Phonenumber")
SELECT / * Remote_mapped (ccc.us.racle.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" "hw". "T_memberinfo" @ ccc.us.racle.com "t_memberinfo") Current $, (Select Distinct Mlog $. "MLOG $." "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" " Phonenumber "from" hw "." Mlog $ _T_MEMBERINFO "@ ccc.us.racle.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, "met" =: 3, "metname" =: 4, "MemberDetails =: 5 where" membernumber "=: 3 And "phonenumber" =: 2
SELECT / * Remote_mapped (ccc.us.racle.com) * / DistINCT log $. "Useersetid" "usersetid" "hw" "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 "hw". "T_customize" @ ccc.us.racle.com "Mas_Tab $" where log $. "Usersetid" = mAS_TAB $. "UsersetID")
SELECT / * Remote_mapped (ccc.us.racle.com) * / Current $. "" "" "" "" "" "" "" "" "" "" "" , Current $. "Begintime", Current $. "Endtime", current $. "Phonestate", current $. "Timetype", Current $. "Looptype", current $. "Resourcety", current $. "ToneGroupID", Current $. "LOOPNO", CURRENT $. "Settime", current $. "Status", current $. "Description" from (select "t_customize". "" "" Phonenumber "," 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_Custom" "Description" "Description" from "hw". "T_customize" @ ccc.us.racle.com "t_customize") Current $, (Select Distinct Mlog $. "UsersetID" "hw". "
Mlog $ _T_CUSTOMize "@ ccc.us.racle.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, "SPECIALPHONE" =: 4, "SETTYPE" =: 5, "begintime" =: 6 , "Endtime" =: 7, "phonestate" =: 9, "loopType" =: 10, "resourcety" =: 11, "ToneGroupID" =: 12, "loopno" =: 13, "Settime" =: 14, "status" =: 15, "description" =: 16 where "usersetid" =: 1
SELECT / * Remote_mapped (ccc.us.racle.com) * / Distinct log $. "Groupid", log $. "Phonenumber" from (SELECT MLOG $. "GROUPID" "GroupID", mlog $. "Phonenumber" " Phonenumber "from" hw "." Mlog $ _T_GroupInfo "@ ccc.us.racle.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.racle .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.racle.com "t_groupinfo") Current $, (Select Distinct Mlog $. "" "GroupID", mlog $. "Phonenumber" " Phonenumber "from" hw "." Mlog $ _t_groupinfo "@ ccc.us.racle.com mlog $ where" snaptime $$ ">: 1 and (" DMLTYPE $$ "! = 'D')) LOG $ Where Current $ "GroupID" = log $. "Genumber" = 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.racle.com) * / DistINCT log $. "GroupID", log $. "MEMBERNUMBER", log $. "Phonenumber" from (SELECT MLOG $. "GROUPID" "GroupID", Mlog $. "MEMBERNUMBER" "Mlog $." Phonenumber "" Phonenumber "from" hw "." Mlog $ _t_groupmemberinfo "@ ccc.us.racle.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.racle.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.racle.com) * / current $. "GroupMemberid", Current $. "Phonenumber", Current $. "GroupID", current $. "Mect" 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 "" MLOG $. "Phonenumber" "Phonenumber" "HW". " Mlog $ _T_GroupMemberinfo "@ ccc.us.racle.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", " "," MemberNumber ") Values (: 1,: 2,: 3,: 4)
Update "hw". "T_groupmemberInfo_mv" set "groupmemberid" =: 1, "phonenumber" =: 2, "groupid" =: 3, "metnuMber" =: 4 where "groupid" =: 3 and "membernumber" =: 4 And "phonenumber" =: 2
SELECT / * Remote_mapped (ccc.us.racle.com) * / distinct log $. "LooptoneID" from (select Mlog $. "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.racle.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", "t_looptone". "ToneGroupId" ToneGroupID "," T_Looptone "." ToneId "" ToneID "," T_Looptone "." Offset "" OFFSET " "," T_looptone "." LoopNo "" LoopNo "from" hw "." T_looptone "@ ccc.us.racle.com" t_looptone ") Current $, (Select Distinct Mlog $." LooptoneID "" LooptoneID "from" HW "" Mlog $ _T_LoOptone "@ ccc.us.racle.com mlog $ where" snapt IME $$>: 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.ness_date) where job =: b3
Begin DBMS_SUPPORT.STOP_TRACE;
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
