Ben Kitchens asks: “I am

Sunday, July 20th, 2003 by Mark Rittman

Ben Kitchens asks:
“I am just starting out as a DBA. I have a question about Oracle 8i. I’m not sure how exactly to have two or more Databases on the instance and then move between them? If you could help that would be wonderful.”
Sure. You can only have one database active on one instance, although […]

Oracle Collaboration Suite Release 2

Saturday, July 19th, 2003 by Mark Rittman

Oracle Collaboration Suite Release 2 is now available for download, initially for Unix and Linux and with Windows to follow.
According to CNET News.com, “The latest version of Oracle’s Collaboration Suite, released Thursday, targets companies looking for lower-cost alternatives to IBM’s Lotus Notes and Microsoft’s Exchange, according to Oracle executives. ”
This latest release of […]

According to The Register on

Saturday, July 19th, 2003 by Mark Rittman

According to The Register on Larry Ellison, “there are four types of technology company right now: companies with products based on a single area of functionality; single product companies; best-of-breed vendors; and integrated suites. But only one type is going to survive”.

An interesting day today for

Saturday, July 19th, 2003 by Mark Rittman

An interesting day today for Oracle.
According to Reuters, “Software maker Oracle Corp. on Wednesday said Chief Marketing Officer Mark Jarvis and George Roberts, the company’s former head of North American sales, had resigned.
Marketing will now report to Executive Vice President Charles Phillips, a former star software analyst at Morgan Stanley who joined Oracle in May. […]

Useful tip for OWB9.2: When

Thursday, July 17th, 2003 by Mark Rittman

Useful tip for OWB9.2: When moving a project from OWB9.0.4. to 9.2., you don’t need to go through the metadata upgrade process as you have in the past. All you need to do is export OWB9.0.4 metadata to an .MDL file as normal, then import it directly into OWB9.2.

Steve Fenwick down at Yeovil

Wednesday, July 16th, 2003 by Mark Rittman

Steve Fenwick down at Yeovil College recently contacted me, and mentioned that their college portal is now running on 9ias release 2. I worked with Steve a while ago and he’s a bit of a guru on SuSE Linux, Oracle and Oracle 9iAS. I remember Steve going home each evening with a server under each […]

The Oracle 9i Grid Cookbook

Wednesday, July 16th, 2003 by Mark Rittman

The Oracle 9i Grid Cookbook is available for download on OTN. I’ve got to put some time aside to look at this; part of me thinks this is going to be the biggest thing since the internet - being able to tap in to the power of the worlds biggest supercomputers, treating processing power like […]

Adjustment Periods and Dimensional Modelling

Wednesday, July 16th, 2003 by Mark Rittman

Oracle Financials (and, in all probability, all other accounting packages) has the concept of adjustment periods, where corrections to transactions already posted on the general ledger can be held in a ‘holding area’ until they are properly attributed. This has the effect of creating a financial calender where you’ve got thirteen or fourteen periods in a […]

Steve Muench picked up on

Wednesday, July 16th, 2003 by Mark Rittman

Steve Muench picked up on my comment regarding the long awaited patch for Oracle 9i, that provides the Analytic Workspace Manager, and enables the OLAP functionality within OWB 9.2 and OWB9.0.4. Steve helpfully pointed to a patch on metalink (2761332) which looked like it might be a contender.
Unfortunately, it was just the 9.2.0.3 patch and […]

According to Igor Machin, the

Tuesday, July 15th, 2003 by Mark Rittman

According to Igor Machin, the post 9.2.0.3 patch for Oracle 9i is now due in August / September. Groan
The new Analytic Workspace functionality in OWB9.2 and OWB9.0.4 relies on this, as does the forthcoming Analytic Workspace Manager add-in for OEM. I’ve been waiting for this patch for around twelve months now; without this […]