"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 [http://www.itweek.co.uk/News/1145023] . "The database giant has extended Error Correction

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

"No one would confuse Microsoft with Oracle. The two software juggernauts have carved out distinctly different markets. So it's not surprising that the companies have differing policies on releasing information about security vulnerabilities." writes Edward Hurley in this searchsecurity.com article [http://searchsecurity.techtarget.com/originalContent/

Frank Bouma's [http://weblogs.asp.net/fbouma/] a .Net [http://www.microsoft.com/net/] developer who normally works with Microsoft SQL Server [http://www.microsoft.com/sql/default.asp]. However, he's recently had to support Oracle 9i for a project he's working on, and

Eric S. Raymond [http://catb.org/~esr/personal.html], he of "The Cathedral And The Bazaar" [http://www.amazon.com/exec/obidos/tg/detail/-/0596001088/markrittmanso-20/104-1962354-7504767] and "The New Hackers Dictionary" [http://www.amazon.com/exec/obidos/tg/detail/-/0262680920/markrittmanso-20/104-1962354-7504767] (good)

"Ease of use and accessibility are essential to widespread acceptance of BI, but simplicity has unfortunately come at the cost of analytic depth." argues Seth Grimes [http://altaplana.com/grimes.html] in this IntelligentEnterprise Article [http://www.intelligententerprise.com/030810/613decision1_1.shtml]. "BI's online

"Prior to Oracle9i, there are two popular methods to extract metadata from data dictionary. The first method involves querying the data dictionary using SQL statements. The second method involves running Export with ROWS=N, then running Import with SHOW=Y. Oracle9i introduces a new Metadata API (DBMS_METADATA package)

The following question [http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3F8EE0A5.3090907%40Oracle.Com&prev=/groups%3Fq%3Dcomp.databases.olap%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den] came up on comp.databases.olap: > "I realise that

I had an email through the other day from Guy Mortenson, who I used to work with at Plus Consultancy before he left to find his fortune elsewhere [http://www.rittman.net/2003/07/21.html]. Guy pointed me in the direction of "Scrum", a metholodology that his

UPDATE 19/10/2003 : According to this article by Sanjay Mishra [http://www.dbazine.com/mishra1.shtml], the feature discussed in this posting (using SQL expressions in Direct Path mode) is only available from Oracle 9i upwards. It therefore won't work for Jon's particular problem, although

I had the following response to a recent posting [http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3406541.1065527999%40dbforums.com&prev=/groups%3Fq%3Dcomp.databases.olap%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den] on comp.databases.olap regarding

"Tom Kyte swears that if you properly analyze your table, the CBO is at the point where you never need hints. I find I still need them 'occasionally', though not very often. Anyone else have opinions? anyone who beta tested 10g see an improvement in the CBO?

Thanks to Simon Dunn [[email protected]] for this Oracle 9i OLAP Technical Article. "There is a new feature in Oracle 9i OLAP which allows the allocation of numbers. Previously, using Express, any allocations had to be hand-crafted using the Express SPL whilst Express-based applications such as Oracle

As an alternative to using Virtual Private Databases to provide row-level security for an Oracle data warehouse [http://www.rittman.net/stories/2003/09/25/securingDataWarehousesWithOidAdvancedSecurityAndVpd.html] , I put together an alternative security set up for a client that achieves much the same thing. The client's data warehouse

"The new CONNECT BY features in Oracle Database 10g

I've managed to install the AWM + requisite patches now, and it's converting a relational star schema as I speak. Some points to note (not all steps listed here BTW) 1. I first applied the 9.2.0.4 patch to an existing 9.2.0.1

Jon Mead [[email protected]] writes on the OTN OLAP Forum [http://forums.oracle.com/forums/thread.jsp?nav=false&forum=16&thread=203117&start=0&msRange=15] : > "I have got the AWM up and running and have spent some time looking at

There's a new series of tutorials available on OTN [http://otn.oracle.com/sample_code/tutorials/cmsxdb/maintoc.htm] around Oracle XML DB [http://otn.oracle.com/tech/xml/xmldb/content.html]. According to the blurb; > "This series of tutorials uses the Simple XML Based Content

Tom Kyte on updating a multi-million row table without encountering rollback issues [http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6407993912330] : > "If I had to update millions of records I would probably opt to NOT update. I would more likely do: CREATE TABLE

According to SDTimes.com [http://sdtimes.com/news/087/story6a.htm], "As J2EE 1.4 inches closer to the finish line, some vendors can’t help but sprint past Sun’s Java Community Process. Take Oracle Corp., which has just posted a preview version of its Oracle 10g app

Bloor Research [http://www.bloorresearch.com/] on new Oracle 10g data warehousing features: "It should be clear that this is a feature-rich and significant release." [http://www.it-analysis.com/article.php?articleid=11265]

The Analytic Workspace Manager can now be downloaded from OTN at http://otn.oracle.com/software/htdocs/devlic.html? http://download.oracle.com/otn/java/olap/awm920.zip [http://otn.oracle.com/software/htdocs/devlic.html?http://download.oracle. com/otn/java/olap/awm920.zip]. It's 217MB and

Jon Mead [[email protected]] and I are co-presenting two slots at the upcoming UKOUG Conference and Exhibition [http://conference.ukoug.org], which runs from 8th - 10th December at the ICC, Birmingham. The first presentation is entitled "Oracle 9i OLAP Uncovered" [http://conference.ukoug.org/display_

Whilst we're on the subject of security, there's a couple of useful papers available on OTN that detail how security on 9iAS works [http://otn.oracle.com/deploy/security/oracle9iAS/index.html]. First up is a detailed technical paper giving best practises for security for Oracle

From VNUNet.com: "Oracle will not announce its pricing strategy for its 10g Database and Application Server products until they ship, but indicators suggest the firm will offer a menu of options [http://www.vnunet.com/News/1143949]."