Re: Oracle License for Optional Packs Question

Thanks for your response. That's good idea, but bit scared on revoking public grants on an assumption that will it affect any another functionalities.

On Tue, Jan 9, 2018 at 11:59 AM, Martin Berger <martin.a.berger_at_gmail.com> wrote:

> Naga,
>
> I don't know of any switch to disable compression in expdp (I assume you
> are talking about this).
> But you can revoke PUBLIC grants on DBMS_METADATA and create your own
> package which is just a wrapper on it. There you can ignore or throw a
> custom error when something like set_parameter(COMPRESSION=>... is used.
>
> execution on DBMS_METADATA can be audited as any package.
>
> hth
> Martin
>
>
> --
> Martin Berger Oracle ♠
> martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
> ^∆x http://berxblog.blogspot.com
>
>
>
> 2018-01-09 7:10 GMT+01:00 Nagaraj chk <nagaraj.chk_at_gmail.com>:
>
>> just like to know , Is it possible to restrict of using compression
>> option in export commands, because as said DBA's accidentally use it :) .
>> With the help of OEM is it possible to enable auditing or track the
>> compression usage ?
>>
>> -Naga
>>
>> On Sun, Nov 19, 2017 at 9:52 AM, Stefan Knecht <knecht.stefan_at_gmail.com>
>> wrote:
>>
>>> The advanced compression option is extremely difficult to not
>>> accidentally use. It's literally everywhere:
>>>
>>> - Datapump export (but only if you compress the data,
>>> metadata-compression is "free")
>>> - Data Guard redo compression (which you can conveniently enable in the
>>> broker which may lead people to think it's a broker-feature and has nothing
>>> to do with the advanced compression option inside the database)
>>> - Securefile compression
>>> - Table & Index compression (this one is kinda obvious)
>>> - Flashback archives with OPTIMIZE DATA turned on
>>> - Heat map features in 12c
>>> - RMAN Backup compression (anything other than 'BASIC')
>>> - Online partition move (even to basic compression - this one is really
>>> evil)
>>> - ... and there's more: https://docs.oracle.com/
>>> database/122/DBLIC/Licensing-Information.htm#GUID-AB56CEE3-9
>>> 55E-4E56-8B44-6075E889C283
>>>
>>>
>>> It's a really sneaky way of pushing this option into so many different
>>> things, and make it really easy to accidentally trigger it somewhere.
>>>
>>>
>>> --
>>> //
>>> zztat - The Next-Gen Oracle Performance Monitoring and Reaction
>>> Framework!
>>> Visit us at zztat.net | Support our Indiegogo campaign at
>>> igg.me/at/zztat | _at_zztat_oracle
>>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l