Rittman Mead - Delivered Intelligence

The following question came up on comp.databases.olap: “I realise that Oracle Personal Express v5 is hopelessly old, but we are trying to replace the app that it runs off. Unfortunately we need to get the data out of the existing database and I can find zero documentation on how to do this. When I had [...]

“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). It allows database users to easily retrieve complete database [...]

UPDATE 19/10/2003 : According to this article by Sanjay Mishra, 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 it would work on an Oracle 9i database. Sorry for any confusion. Jon Mead came up [...]

I had the following response to a recent posting on comp.databases.olap regarding Oracle 10g OLAP New Features; “thanks for the links concerning Oracle 10g. Is the software for 10g already available (evaluation, beta …)? I can’t find downloads in technet. Do I need to have a “10g DB” or can I run a 10g Discoverer [...]

“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? IT tends to get a little better with [...]