Re: Oracle query help! (86 Views)
Reply
Valued Contributor
Ralph_Furino
Posts: 169
Registered: ‎04-27-2011
Message 1 of 2 (97 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!

 

Ralph

Please use plain text.
Honored Contributor
EWillsey
Posts: 1,708
Registered: ‎04-20-2010
Message 2 of 2 (86 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.
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