Oracle query help! (212 Views)
Trusted Contributor
Posts: 179
Registered: ‎04-27-2011
Message 1 of 2 (212 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!



Honored Contributor
Posts: 2,003
Registered: ‎04-20-2010
Message 2 of 2 (201 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).

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.