Rittman Mead - Delivered Intelligence

Arup Nanda has written an article for dbazine.com on the various methods for implementing partitioning for existing Oracle tables. Arup goes through a number of different options, including Creating the partitioned table from scratch, using CREATE TABLE … AS SELECT to select from the original table Creating the table, then populating it from the original table [...]

Garry Robinson has put together a useful guide to iSQL*Plus, a version of SQL*Plus introduced from Oracle 9iR2 that is delivered through a web browser. It talks you through setting up the tool, configuring it to work with Apache, defining which instances it can connect to, and points out a patch that should be applied [...]

“Oracle has again extended maintenance support for customers of its 8i database on many major platforms, this time until 2005, giving firms another year to migrate to 9i or 10g.” reports vnunet.com. “The database giant has extended Error Correction Support (ECS) on the Oracle 8i database version 8.1.7 and 8.1.7.x until 31 December, 2004 for [...]

Ralph Kimball, author of The Data Warehouse Lifecycle Toolkit, has put together a new article on reviewing data warehouse data models. Ralph was an early advocate of dimensional data warehouses, and the modelling techniques detailed in his books and articles are the recommended way that Oracle data warehouses are designed. According to the article; “People often engage [...]

If you’ve ever had to port a Microsoft SQL Server or Access database over to Oracle, you’ve probably come across the different way joins are put together for these databases. For example,you might come across a query looking like this; SELECT pub_name, title FROM publishers INNER JOIN titles ON publishers.pub_id = titles.pub_id At first you [...]