Steve Callan

A previous article covered some of the features of Visio, “The Microsoft Office Business and Technical Diagramming Program.” One of Visio’s key features is its ability to reverse engineer a database, and in this article, we will take a look at doing exactly that using the sample schemas Oracle provides. Comparing the results of Visio’s […]

Many DBAs find themselves working with someone else’s database design. Unless you are involved with building or designing a new application or database from scratch, when else would you have the opportunity to use a CASE tool? One of the points to take away from having read this article is that a CASE tool can […]

In this final part of the series, we will look at some additional resources for HTML DB, which are freely available. The resources include training documentation, blogs and news feeds, a free workspace (hosted by Oracle), and a user forum. Oracle Corporation typically posts a statement of direction on the OTN Web site, and we […]

As an Oracle DBA, you know that Oracle is a relational database management system and that it performs many complex functions well. In the pressure to learn how to be a DBA or what it is you should be doing, it is hard to take the time to sit back and appreciate the origins of […]

In part 4 of the HTML DB series, I will cover the steps of upgrading to version 1.6 and creating a simple Web service. The upgrade/installation steps come straight out of the March 2005 Oracle® HTML DB Installation Guide, Release 1.6. The steps to create a simple Web service are from the Oracle® HTML DB […]

In the first two parts of this series, we looked at the basic HTTP Server behind HTML DB (and Application Server) and the basic installation and setup of HTML DB itself. In this article, we will look at a simple example of adding a page to an existing application and detail some of the steps […]

In part one of this series, the installation and basic configuration of Oracle9i’s HTTP Server was covered. This part of the series looks at how the HTTP server has changed with respect to how you get it and how you use it. Part of the process is very easy, and other parts are somewhat confusing. […]

In a previous article on LogMiner, the steps for setting up your environment to use this tool were shown. Oracle’s documentation lists several ways LogMiner can be used to recover lost data. Generally, “lost” in this case means a user error induced type of loss. Under the appropriate conditions, you can strike gold with LogMiner. […]

Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle’s strength as a relational database management system and the power of the Internet. This resource is extremely easy to visit and requires virtually little in the way of installation […]

In Part 1, I covered some of the operational requirements for using Data Guard and the options (physical and logical) you have in deciding which type of standby database you want to employ. Part 2 starts off with step-by-step coverage of preparing your environment for Data Guard. One of the driving factors for using Data […]

Pro*C is another one of those tools or features from Oracle that keeps a low profile, quietly waiting its turn for you to use it when the need arises. With a little searching on various Oracle-related Web sites, you can read about how others have used Pro*C to greatly reduce processing time for some operation […]

If it has happened once, it has happened a million times, and that is getting the irritating ORA-01031: Insufficient privileges error. You can get this error even when you think you are in God mode as in the popular computer game Doom. Wouldn’t it be nice if Oracle had Very Happy Ammo "idkfa" or God […]