A new test Oracle database was created by supposely duplicating an existing production database. In this new database, when I try to delete records using queries, I get an error msg that it can not delete due to lock violations. All these queries work in the production database. I did go in and delete the tables and relink creating different keys. Then some records will get deleted but not all. Also it crashed the ms application and reboots itself.
It seems to be able to do all the other queries ok.