Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
Upgrading From Express Server, 3 of 7
Oracle OLAP runs within the Oracle database kernel. An Oracle OLAP session is always connected to the database. You do not open a connection with the database as a separate or optional step.
You can move data between an analytic workspace objects (such as variables and dimensions) and relational tables in the following ways:
SQL
IMPORT
command facilitates bulk data transfer from relational tables into the analytic workspace, and a new SQL INSERT DIRECT
command facilitates data transfer from the analytic workspace into relational tables.CNV_CWM.TO.ECM
creates an ECM-type analytic workspace from relational tables.ODBC is not available, and thus access to third-party databases is not available directly from Oracle OLAP.
Oracle Express Relational Access Administrator and Oracle Express Relational Access Manager are not available.
|
![]() Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|