Skip to Main Content
  • Questions

  • OLAP - How can I check that databae uses it

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: November 19, 2020 - 2:01 pm UTC

Last updated: November 24, 2020 - 1:26 am UTC

Version: oracle datbase 11.2 and 12.2

Viewed 1000+ times

You Asked

Hello,

This is my first post, please be understanding :).

I have questions about olap:

1. In Oracle 11.2, olap was free (In Oracle 12.2, olap requires a license)?
2. What happens when I import a base using olaps into the environment without olap?
3. How to check if the factual database uses ola?


select
   name,
   first_usage_date,
   last_usage_date
from
   dba_feature_usage_statistics
where
   name like '%OLAP%'
and
   first_usage_date is not null;

Is that enough?

4. how i check that database is warehouse ?

Thank you
Regars
Krzysztof

and Chris said...

1. If you have questions about which features are in which editions or require options, the best place to check is the License Guide.

This shows OLAP as a separately licensable option in 11.2:

https://docs.oracle.com/cd/E11882_01/license.112/e47877/options.htm#DBLIC151

And 12.2:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

2. I'm not sure what you're asking here.

3. That gives an indicator, but as MOS note 739032.1 says:

There is no easy or 100% guaranteed method to determine if OLAP has been (or currently is) in use.

Check the note for full details.

4. A data warehouse is more a description of how you design the data structures and use the database. Usually the tables will form a star-schema or other design optimized for reporting, with a BI tool being the main application people use to interact with it.

There are no specific settings that make it a data warehouse.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

point 2 details ...

Krzysztof, November 20, 2020 - 10:17 pm UTC

Hello,

thank you for the quick reply.
With reference to point 2:
example if I export schemas databse with database use olap (but I don't know if it is) and import this databe without olap.
Will something not work?
Will I see some wrong objects?

Thx
Krzysztof
Connor McDonald
November 24, 2020 - 1:26 am UTC

OLAP is no different anything else in that respect, for example, if you export schema X that references an object in schema Y, and you do not export schema Y as well, then you'll get a warning on import.

If you have OLAP installed but you are not using it anywhere, then an import would most likely be error free. If you *were* using OLAP objects and imported into a database without them, then import will likely report the inconsistency
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.