| SQL & PL/SQL [message #601730] |
Mon, 25 November 2013 01:34  |
 |
varshbugad
Messages: 1
Registered: November 2013
|
Junior Member |
|
|
I am trying to test archiving on one schema. But below update query takes too much time to run.The same query runs on other schema properly.
please suggest solution.
UPDATE OW_WORKITEM_INSTANCE SET ARCHIVEPROCESS_COUNT=1 WHERE WORKITEMID=3556;
|
|
|
|
| Re: SQL & PL/SQL [message #601731 is a reply to message #601730] |
Mon, 25 November 2013 02:04  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
Hi and welcome to Orafaq. You have posted, basically, no useful information.
Take a look at this page , spend some time understanding the content of the links, read the posts and understand them, then if you're still having problems, post back paying particular attention to Blackswan's post
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
