Blog Aggregator - Amardeep Sidhu

I installed HTMLDB (off the 10.2 Companion disk) on Solaris today. Install seemed to run OK and at the end it told me that the HTMLDB instance had started and could be accessed at:http://wintermute:7778When I tried to access it, no joy. Said it couldn’t connect. I tried using opmnctl to check the status and found that opmn itself was up but none of the managed services were. Stopping and

I was just having a play around on one of my test/sandpit databases (”small database on a low power machine that I use for testing out scripts &c, no live data and if the database gets destroyed I just have to wipe out the files and create a new one” type of thing). I’d forgotten the SYSDBA password (for sandpit systems I use the SID as the SYSDBA password so don’t bother to write it down, for

When writing code to do repetitive tasks, the two primary approaches are iteration and recursion. Generally you can use either one interchangeably, but potentially with different performance and complexity.

A recursive function calls itself (possibly more than once), with different parameters, and defines an exit clause that is guaranteed to be reached.

CREATE OR REPLACE FUNCTION

I thought I’d provide you with a couple of quick SQL*PLUS tips and tricks this week. Some of the features are new in 10G, while others are available in earlier releases. I think you’ll find them all to be very helpful.

I thought I would deviate from my usual discussion on 10G technical topics for one blog. I’d like to talk about non-technical skill sets and the important role they play in our careers.

It used to be that you could get by with a total lack of interpersonal skills in our profession. Well those days are long gone. If you want to succeed, you’ll need to learn how to communicate effectively and play well with others. This blog contains a few pearls of wisdom, and a story or two, to help you become a well-rounded technician that is on the fast track to a successful career.

Let’s finish this series on 10G Data Pump by investigating the Data Pump Import utility. In this blog, we’ll learn how to execute 10G Data Pump Import and take advantage of some of its more popular features.

This is part three of a series on 10G Data Pump. In part one, we reviewed a few of the new features that make Data Pump Export and Import attractive alternatives to their ancestors, Export and Import. Part two focused on the 10G Data Pump architecture. We continue the discussion in this blog by learning how to use 10G Data Pump Export to “pump” data out of an Oracle database.