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/db
of 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.
show nls_lang
Note: Refer to "Localization Support" for more information on character sets.
database attach dbname
updatecharset
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.
update
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|