Oracle query help! (99 Views)
Valued Contributor
Posts: 169
Registered: ‎04-27-2011
Message 1 of 2 (99 Views)
Accepted Solution

Oracle query help!

Can anyone give me the Oracle query that will move certain users that have a request in the TSEVENTDAT table from one workgroup server to another?


Something like:


MOVE from edforworkgroupid = '2' where edloginid = 'ralph' to edforworkgroupid = '1';


(I want to move every record in the tseventdat table where edloginid is ralph to edworkgroupid = '1')


Thanks in advance!



Please use plain text.
Honored Contributor
Posts: 1,708
Registered: ‎04-20-2010
Message 2 of 2 (88 Views)

Re: Oracle query help!

First turn off the event server, then run this query:


update tseventdat set edForWorkgroupID = 2 where edLoginId = 'ralph' AND edForWorkgoupId = 1


Then turn on the event server.


Note that not all events are processed by the first available server.  So reassigning some events won't help (like audit logging, DCI).

Please use plain text.