Re: Oracle License for Optional Packs Question

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