Crashing in public...
This is why I have a “no demo” clause in my contract these days. Well, I’ll demonstrate with Sqlplus but that is about it. Funny, I have taking to running my demo databases like production systems. I travel with my backups on different storage devices – just in case. Call me paranoid. The only time I had a demo mess up big time was when I answered an asktom question but used my “production” instance to do it. I changed something that messed up one of my scripts. I will never do that again (they are my production instances and as such I have no right to be using them to answer questions on the fly, that is for TEST).
True story – I staged a small demo in the asktom database one day, one you could run from the site. It included in it the fatal words “CREATE VIEW V AS …”. Anyone care to comment on what a view named V might do to an HTMLDB (Oracle Application Express) application? Anyone care to comment on how long it might take to figure out what you’ve done (not long). Never use production to ad-hoc something, the smallest of changes can have unintended side effects.
Another new blog to add to the lists. I edited one of Eric’s papers (learned a thing or two, but that went both ways) recently and suggested he started blogging on topics like that as the technical content was “high” but understandable. Check it out, interesting investigations using redo to see what Oracle does.