Author Archives: arkytekture
Oracle VM VirtualBox If you haven't had a chance to work with it, consider visiting http://dlc.sun.com/virtualbox/vboxdownload.html It runs on windows, linux, mac os/x and solaris. I downloaded a pre-installed VM with a database, development tools, and an application server pre-installed. Though I had the minimum required config (~2 GHz processor, 2 GB RAM), I was [...]
Extend Oracle's SQL Developer to search PSOUG web pages and see how much more productive you can be! Anyone who's used SQL Developer may have noticed the search engines tucked away in the upper right corner of the screen. With a nod to Firefox, the people who created SQL Developer made it easy to look [...]
Using import, export, and strings command to maintain software baselines and Oracle shells for productized software development.
it would not be feasible to use the shiny, trusted front-end tool that the DBAs had to browse and navigate to each application schema and manually click on each sequence to reverse engineer it. We needed dynamic SQL to do them all in one shot but without all those those SYS, sample and unused schemas detailed in support docs 207560.1 and 270516.1
Besides changing commit intervals, noarchive, nologging, and SQL append hints can greatly aid bulk-loading data to an Oracle system.
The choices you have on implementing XML depends upon the architecture of your solution. 1) Do you plan to a) parse the XML docs and store them into multiple relational tables ? If so, what languages or techniques do you intend to use to accomplish this? b) store an XML doc in a single XMLType [...]
to share some real-world experiences (ok, maybe thinly disguised ones) that illustrate either database technology issues, software engineering practices, or some other philosophy.