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


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


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?

   name like '%OLAP%'
   first_usage_date is not null;

Is that enough?

4. how i check that database is warehouse ?

Thank you

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:

And 12.2:

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)


point 2 details ...

November 20, 2020 - 10:17 pm UTC

Reviewer: Krzysztof from POLAND


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?


More to Explore


The Oracle documentation contains a complete SQL reference.