Today Cary Millsap posted his second story on this new blog site carymillsap.blogspot.com called: “How the OFA Began, Part 1“. What Cary’s story actually triggered on my part, was doing a small trip back into memory lane. This was probably also caused because today I was working with one of my “newbie” colleagues. He won’t like the term when he reads it, but in my mind this is still the case. The guy has a big advantage, he is keen and he is eager. He has also a disadvantage; he is eager. He reminds me a little at when I started working in the IT DBA field, a promising raw diamond, that still has to be cut. So today, before I knew that Cary would post his piece about OFA, I told him about OFA. Showed him the link to the OFA Hotsos site (thank you Doug) and printed it out for him. I wanted to let him realize that a lot of stuff out there in the DBA world was there for a reason and shouldn’t be taken for granted. Also that there was more to those “standards” then he probably knew or realized.
Author: Marco Gralike
Cary Millsap posted his first post on his personal blog site: http://carymillsap.blogspot.com. His first interesting…
A week ago, someone had some problems with DBMS_XMLSCHEMA.PURGESCHEMA (available in Oracle 11g). In principle, the problem he had, was that a registered schema could not be deleted via the normal procedures/methods, or at least this was claimed to be the case…
The problem was solved via a very intuitive way (direct delete via a user view), but one I wouldn’t recommend PLUS it also raises some questions…(although I am still not sure how under what circumstances this was doable / which privileges used to make this happen)…
Have a look at the following OTN Forum post, regarding “Purgeschema“. A description of the view user_xml_schemas is shown below as a reference.