|Oracle9i OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)
Part Number A88755-01
Upgrading from Express Server, 2 of 5
In Oracle9i, the term database refers only to the relational database. Express databases are now called analytic workspaces. In OLAP Services, an analytic workspace can be used either as a transient data cache or as a persistent data repository. You can also use it to store SPL programs, Express Common Metadata (ECM), and data definitions.
Follow these steps to upgrade an Express database for use as an analytic workspace in Oracle9i:
olap/dbof the installation directory for databases. Other directories can be added to the search path by adding them to the ServerDBPath configuration setting. If a database is not in the search path, you will need to specify the full path name each time you attach it.
oracle) has write access.
For example, if the database is owned by
oesdba, and the primary group is
dba, then the installation user (such as
oracle) must also be a member of the
dba group, and the
dba group must have write access.
Note: Refer to "Localization Support" for more information on character sets.
Important: Proceed to the next step only if you are sure that the server character set includes all of the characters in the database. If you have any doubt, you should check the data stored in text variables to verify that it is readable. After you have updated the database, you cannot change its character set.