Oracle query help! (146 Views)
Reply
Trusted Contributor
Ralph_Furino
Posts: 179
Registered: ‎04-27-2011
Message 1 of 2 (146 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,815
Registered: ‎04-20-2010
Message 2 of 2 (135 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