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.
www.xmldb.nl Posts
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.