Import An Oracle Dump File

These are the steps I normally follow when restoring Oracle dump files for the purposes of my work. I prefer to logically keep the restored entities logically and physically separate through the use of tablespace and associated datafile(s) respectively. Create and assign the user to the earlier defined tablespace. If I want the created user … Continue reading Import An Oracle Dump File

Advertisements

This is not an ACL project Problem, My Solution

I was greeted by the unpleasant message "This is not an ACL project" from a dialog box after I tried opening an ACL Analytics 11 project and had selected Working from the earlier dialog box that welcomed me when I opened the project. This is a message I haven't seen before, but I just suspected … Continue reading This is not an ACL project Problem, My Solution

Creating Dynamic Log Files In Zend Framework (ZF)

The motivation for wanting to do something like this could be any of the following: You want to have separate logs depending on the context (i.e. application, testing, development, etc) in which the application is being run and you do not want to inherit a context and override some values in another context in the … Continue reading Creating Dynamic Log Files In Zend Framework (ZF)

Talk: Web Scraping, An Important Technique For Data Extraction

After the successful launch of Java 7, late last year, here in Ghana by Coders4Africa where I was the main speaker highlighting on the new language changes in Java, I am pleased to announce that I will be making another presentation on Web Scraping at the upcoming meeting. Topic Web Scraping, An Important Technique For … Continue reading Talk: Web Scraping, An Important Technique For Data Extraction

Dropping All Tables In A MySQL Database Using A Stored Procedure

Using an engine like InnoDB, which enforces referential integrity through the use of foreign keys, poses a little problem when deleting a table whose field(s) act as foreign keys in other table(s). Dropping an entire database may seem like a convenient approach to use, but will not be an option to users who do not … Continue reading Dropping All Tables In A MySQL Database Using A Stored Procedure

How To Solve MySQL Character Sets and Collations Mixing Problems

Character sets and collations enable MySQL to perform comparisons on strings, so if have two or more columns with different character sets and/or collations are used in a way that performs some comparison of some sort on them (either using =, >, <, , a JOIN ON, etc), MySQL will be a little confused and … Continue reading How To Solve MySQL Character Sets and Collations Mixing Problems

How To Create a Gherkin Syntax Highlighter In gedit

So, I woke up today and did a little bit of surfing, like I always do, and came across Cucumber, a Behaviour-Driven Development (BDD) framework in Ruby¬†and I bought into the idea as it focuses on the behavioural aspects of the system by allowing you to describe and test the system's behavior. Well, like a … Continue reading How To Create a Gherkin Syntax Highlighter In gedit