ORACLE

Problem: You have a table sitting inside a MySQL database and your aim is to move it into your ORACLE database. Sounds easy? Well, it ought to be a lot easier than it currently happens to be. Here, we look at a worked example that involves using ORACLE external tables.

Some people can be frightened off by the thought of building a Linux web server from source, let alone adding PHP support. There are, of course, other options available such as packaged binary distributions of Apache, PHP, and Zend Core for ORACLE. But if building your own Apache installation from scratch is non-negotiable, then it's time to roll those sleeves up again.

In this article, we throw caution to the wind and go one step further and add ORACLE support into the mix. In for a penny, in for a pound as the saying goes!

For the benefit of Linux users who wish to build Apache and PHP from source, what follows is a cookbook approach to building and configuring Apache 2.2.3 and PHP 5.2.0 for use with a locally installed ORACLE database.

Well, the aim was simple enough: to have a go at getting Drupal to run under Win2k and ORACLE 10g Express Edition.

Famous last words? ...

The OraDrup project was set up in April 2006 to bring the Drupal 4.7.x content management system into the world of the ORACLE DBMS. This was chosen because "it was there" and to date, this lofty aim appears to have stifled those brave enough to attempt it, which seems a bit of a shame.