Oracle releases BI extension for Open Office

Oracle released a new BI extension for Open Office with the latest Open Office release (v. 3.3) . This extension gives us the ability to embed information from BI EE 10g into Open Office Calc, Writer and Impress documents (equivalents of Excel, Word and Powerpoint).  OO Calc supports the ability to embed entire reports including tabular views, pivot tables and charts. OO Writer and OO Impress only support embedding of charts into the documents.

via Rittman Mead Consulting » Blog Archive » Oracle releases BI extension for Open Office.

Oracle Data Archiving

Oracle Data Archiving:

Archiving data requires creating a strategy for long-term data retention. This strategy is usually determined in collaboration with IT, line of business and legal teams. This strategy could be impacted by one of two types of requirements – internal requirements, where for example a company must keep all customer records accessible and online for a period of 24 months, or requirements that stem from government regulations like Sarbanes-Oxley, HIPAA, PCI, etc. For example, HIPAA requires that medical records be retained up to two years after a person’s death. Sarbanes-Oxley requires audit data be kept for seven years after the conclusion of the audit and CFR (Life Sciences) requires that pharmaceutical companies retain clinical trial data for 35 years. Requirements are extremely stringent for companies that must retain data for legal purposes, and most are not prepared to hold data for such long time frames, let alone guarantee it hasn’t been altered in any way.

Oracle Changing the Character Set of an Oracle Database

Oracle Changing the Character Set of an Oracle Database

Changing the Character Set After Database Creation

In some cases, you may wish to change the existing database character set. For instance, you may find that the number of languages that need to be supported in your database have increased. In most cases, you will need to do a full export/import to properly convert all data to the new character set. However, if and only if, the new character set is a strict superset of the current character set, it is possible to use the ALTER DATABASE CHARACTER SET to expedite the change in the database character set.

madhatter to the world: Install Oracle 10g on Mac OS X 10.4 (

madhatter to the world: Install Oracle 10g on Mac OS X 10.4 (“Tiger”)

The last two evenings I spent on installing Oracle 10g on my iBook. Don’t ask why I have to have Oracle on an iBook, I just wanted to play around with it. Problem was that I haven’t read somewhere before that right now no Oracle database seems to run on Apple’s Tiger yet but only on 10.3 (“Panther”).
When I realized that, I already had tried to solve the problem a few hours. So I wasn’t in the mood to let it go. There had to be a way and I think – a few minutes ago – I found it.

Sergio's Blog: Installing Oracle Database 10g on Mac OS X

Sergio’s Blog: Installing Oracle Database 10g on Mac OS X: Sergio’s Blog
Oracle HTML DB tips, tricks and examples.
« HTML DB 1.6 Available for Download | Main | Updated VMWare Kits: Desktop Data Center »

January 02, 2005

Installing Oracle Database 10g on Mac OS X

Recently Oracle and Apple announced the availability of Oracle Database 10g for Mac OS X. In in this — longer than usual — blog post, I document my experience installing the Oracle database on my Mac. In a subsequent post, I’ll talk about my experience installing Oracle HTML DB. These instructions should not be considered a best practice, but they are steps that worked for me. I tried to incorporate as many screenshots as possible to help you when you are performing the install.

1. Hardware Requirements

The Quick Installation Guide states the following hardware requirements:
• 512 MB RAM
• 1GB or twice the size of RAM swap space
• 400MB of disk space in /tmp
• 2Gb disk space for software files
• 1.2Gb disk space for database files

I performed my installation on an

Unload/Load Date/Time for Oracle

Store the VMS date as timestamp in oracle.

1) Use “delimited” text for unload
2) Before you invoke SQL*Loader ,define the NLS date (both on OS and
init*.ora) to match the date/timestamp format on unloaded file.
e.g If the date on unloaded file : 1998012113351752
VMS : $ DEFINE/SYSTEM NLS_TIMESTAMP_FORMAT
“YYYYMMDDHH24MISSFF”
Init*.ora : nls_timestamp_format=”YYYYMMDDHH24MISSFF”