Wednesday, October 29th, 2003 by Mark Rittman
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 using INSERT [...]
Sunday, October 26th, 2003 by Mark Rittman
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 [...]
Thursday, October 23rd, 2003 by Mark Rittman
“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 [...]
Thursday, October 23rd, 2003 by Mark Rittman
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 us [...]
Wednesday, October 22nd, 2003 by Mark Rittman
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 might think [...]
