select comp_name, version, status from dba_registry where comp_name like '%OLAP%' order by 1 DESC;Typical output if OLAP is installed:
| COMP_NAME | VERSION | STATUS |
|---|---|---|
| Oracle OLAP API | 11.2.0.4.0 | VALID |
| OLAP Catalog | 11.2.0.4.0 | VALID |
| OLAP Analytic Workspace | 11.2.0.4.0 | VALID |
You can also use:
select * from v$option where parameter='OLAP';
| PARAMETER | VALUE |
|---|---|
| OLAP | TRUE |
If OLAP option is not inatalled in Oracle 11g Express Edition, how to install it manually?
ReplyDeleteYou could potentially use the steps outlined in my other post "How to enable OLAP in an Oracle 11gR2 database". It may be that Oracle Express is shipped With some limitations. This you will need to check up-front. Good Luck.
ReplyDelete