MQSeries.net :: View topic - Workflow 3.404 on Solaris with Oracle 9.2.0.5

RichA

We have a Workflow runtime configuration on Solaris which has recently undergone a patch for it's Oracle install. (I'm not an Oracle person so can't answer very many questions without going through someone else) The workflow is failing because of Trigger errors, as this is a proof of concept I don't have to worry about the state of anything in the database so what I would do if this were DB2 is drop and recreate the database, or possibly a rebind might work. I have a client connected to the config on a windows machine and can see there are workitems left over from before the patch but cannot terminate tham as it times out. Ideally I want to just drop the database and use fmczutil to create a new one from scratch. How do I go about this?