regisdaniel
asked on
Oracle Materialized View Licensing
Hi Experts!
I built an application that makes use of Materialized View on Oracle Database.
Today, a customer said that, to use this resource, they need to change its license from Oracle 10G Stardard Edition to Oracle 10G Enterprise Edition, since Materialized View is not present on the Standard Edition.
Is it true? Is Materialized View licensed to use only in a Enterprise Edition Database?
Ps.: There is no use to advanced features, like Query Rewrite.
Thanks a lot!
I built an application that makes use of Materialized View on Oracle Database.
Today, a customer said that, to use this resource, they need to change its license from Oracle 10G Stardard Edition to Oracle 10G Enterprise Edition, since Materialized View is not present on the Standard Edition.
Is it true? Is Materialized View licensed to use only in a Enterprise Edition Database?
Ps.: There is no use to advanced features, like Query Rewrite.
Thanks a lot!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi sdstuber and woolmilkporc!
Thanks for your fast reply.
Checking the Oracle Documentation (http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/editions.htm#CIHDDBCG), we can see on Table 1-1 that the "Summary management—Materialized View Query Rewrite" is only available on the Enterprise Edition.
I also checked the paper from Burleson Consulting and my doubt started just after reading that article... Reading Oracle Documentation I understood that only View Query Rewrite was a EE feature... But, Burleson Consulting said that the whole feature was present only in EE.
None os my Materialized Views was created using the ENABLE QUERY REWRITE clause.
Does anybody haves an advice?
Thanks for your fast reply.
Checking the Oracle Documentation (http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/editions.htm#CIHDDBCG), we can see on Table 1-1 that the "Summary management—Materialized View Query Rewrite" is only available on the Enterprise Edition.
I also checked the paper from Burleson Consulting and my doubt started just after reading that article... Reading Oracle Documentation I understood that only View Query Rewrite was a EE feature... But, Burleson Consulting said that the whole feature was present only in EE.
None os my Materialized Views was created using the ENABLE QUERY REWRITE clause.
Does anybody haves an advice?
'Feature Availability'.
I don't think 'feature' implies 'free'. Or is that 'options'. I always confuse the two.
That list also shows RAC as available and that isn't free.
I don't think 'feature' implies 'free'. Or is that 'options'. I always confuse the two.
That list also shows RAC as available and that isn't free.
RAC is "built in" to Standard Edition. Included at no extra cost. For Enterprise you do have to pay for it.
If it says "Extra cost option" - in the licensing link above then you must pay extra for it, otherwise it should be included without extra fees.
I wouldn't trust the Burleson writeup. It's just a summary and is probably confusing the rewrite option and advanced replication with the basic materialized view option.
And, let me repeat. Even though the licensing link above is from Oracle. The BEST (and really, the ONLY) true resource for your particular licensing options is your Oracle Representative.
If it says "Extra cost option" - in the licensing link above then you must pay extra for it, otherwise it should be included without extra fees.
I wouldn't trust the Burleson writeup. It's just a summary and is probably confusing the rewrite option and advanced replication with the basic materialized view option.
And, let me repeat. Even though the licensing link above is from Oracle. The BEST (and really, the ONLY) true resource for your particular licensing options is your Oracle Representative.
based on what you have said, you "should" be ok to use materialized views within standard edition, and at no additional cost. BUT you should confirm with your oracle rep. Only they are authorized to give you the real answer to what your system is licensed for.
I stand corrected.
Just to be clear in my recommendations about contacting the Oracle Representative.
I mean the Rep of your customer, since that is who must be sure they are in compliance with their licensing.
I mean the Rep of your customer, since that is who must be sure they are in compliance with their licensing.
ASKER
Hi all!
Thanks for all answers!
My Oracle Represantative said that the materialized views could be used without problems, since Query Rewrite option is turned off.
Thanks for all answers!
My Oracle Represantative said that the materialized views could be used without problems, since Query Rewrite option is turned off.
http://download.oracle.com/docs/cd/B19306_01/license.102/b14199/editions.htm#BABJICBB
of course, the BEST option for any licensing question is always to contact your Oracle Representative to confirm exactly what you are and are not licensed for.