Since 9 March 2007 this “notepad” version of a website exists. Thank you for your support and interaction. My best wishes for 2008, a happy and healthy New Year. Click on the image to enlarge. Marco Related posts: Doug Differences – Great sense of Humor Enjoying the Sun in Dallas OOW2K6 – Unbreakable Linux – …
Yearly Archive: 2007
Dec 31 2007
Doug
Dec 21 2007
Virtual Columns and Binary XML (Storage) Schema Validation
One of the problems I saw lately was mentioning binary XML encoding, so I was able to help out more specific on these issues then normally when issues arise on the XMLDB Forum.
Two of them caught my attention:
- [11g] XML Schema full validation with binary XML?
- [11g] Adding a virtual column to a binary XML table?
Both are issues are related to the same person, Christian Soutou. I am not really sure what he wants to achieve, but the discussions brought me some new insights.
Read more…
Dec 21 2007
Encoding and Validation of Binary XML Storage of XML Schema-Based Data
One of the new things in 11g is the possibility to set the method of how to enforce the validation / encoding of your XML document, straight away via embedding these options in your binary XML storage structure. It is just a small entry in the manual, but I think an important one. That’s why I wrote this small post, to emphasize this.
These extra options can be enabled during the creation of your binary XMLType table / column(s).
You have the option to use:
Read more…
Dec 19 2007
Marcelo’s Ochoa’s: “Uploading WikiPedia Dumps to Oracle databases” Blog Post
I liked Marcelo’s post about “Uploading WikiPedia Dumps to Oracle databases” very much. One reason is that he actually did that, what I was trying to explain / trying to bring across, to my audience during UKOUG. If you are going to work with the XMLDB functionality, think about what you trying to achieve regarding …
Dec 15 2007
HOWTO: Resurrect your xdbconfig file when it gets corrupted
Flavio Casetta, has a great post on his blog “Annals of Oracle’s Improbable Errors” on how to resurrect the xdbconfig.xml when it gets corrupted due, for instance in his case, an unlucky update via WebDAV. This caused the brilliant Oracle error code: ORA-31114: XDB configuration has been deleted or is corrupted . The solution pointed …
Dec 07 2007
UKOUG 2007 – Finishing up.
For prosperity and to ramble up all the written posts who added to my feelings about how I felt about (and what I have seen) UKOUG 2007, here my shortlist (there are many others) of posts regarding this years conference (in no special order). The Pythian Blog Site SELECT * FROM V$UKOUG WHERE DAY BETWEEN …
Dec 03 2007
UKOUG Ramblings
Dec 01 2007
My UKOUG Agenda
Nov 27 2007
The use of namespaces within XMLTable or the table(xmlsequence(extract()) constuct
Or in other words how to use namespace based on the “new” method (Oracle 10.2 and above) or the method that can be used on older versions (and newer of course). This post is just a reminder, because this is always a hassle (and I never can remember when I need to). The post is …

Recent Comments