Skip to Main Content
  • Questions
  • OLAP - How can I check that databae uses it

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

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

Answered by: Chris Saxon - Last updated: November 19, 2020 - 6:12 pm UTC

Category: Database Administration - Version: oracle datbase 11.2 and 12.2

Viewed 100+ 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 we 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.

and you rated our response

  (1 rating)

Reviews

point 2 details ...

November 20, 2020 - 10:17 pm UTC

Reviewer: Krzysztof from POLAND

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

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.