Disable Oracle Feature [message #679088] |
Mon, 03 February 2020 09:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/50158ae5271bfc22a1bd70b8d9bf0326?s=64&d=mm&r=g) |
rajesh_b
Messages: 20 Registered: December 2019
|
Junior Member |
|
|
Kindly update how to disable below features
Advanced Compression |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE|2020.02.02_06.44.19|1571512636|11.2.0.4.0 | 2| 4|TRUE |2020.01.26_04.42.05|2020.02.02_06.44.19|compression used: 0 times
Advanced Security |Oracle Utility Datapump (Export) |NO_CURRENT_USAGE|2020.02.02_06.44.19|1571512636|11.2.0.4.0 | 2| 4|TRUE |2020.01.26_04.42.05|2020.02.02_06.44.19|encryption used: 0 times
I am using below options
EXPDP xxx/xxx@xxxlty DIRECTORY=BCK_DIR DUMPFILE=backupdev.DMP LOGFILE=backupdev.LOG flashback_time=systimestamp compression=none encryption=none
|
|
|
|
|
|
Re: Disable Oracle Feature [message #679129 is a reply to message #679128] |
Sat, 08 February 2020 06:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/50158ae5271bfc22a1bd70b8d9bf0326?s=64&d=mm&r=g) |
rajesh_b
Messages: 20 Registered: December 2019
|
Junior Member |
|
|
options_packs_usage_statistics.sql
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
------- Name : options_packs_usage_statistics.sql
------- MOS DOC ID 1317265.1
MC: copyrighted script removed
[Updated on: Sat, 08 February 2020 07:27] by Moderator Report message to a moderator
|
|
|
|
Re: Disable Oracle Feature [message #679132 is a reply to message #679130] |
Sat, 08 February 2020 23:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/50158ae5271bfc22a1bd70b8d9bf0326?s=64&d=mm&r=g) |
rajesh_b
Messages: 20 Registered: December 2019
|
Junior Member |
|
|
It is using DBA_FEATURE_USAGE_STATISTICS , but I didnt see the advanced compression and advanced security options when I query the view directly. It only shows Oracle Utility datapumt (Export) and (Import)
SQL> select name,detected_usages,currently_used,last_usage_date,description,feature_info from DBA_FEATURE_USAGE_STATISTICS order by name;
NAME DETECTED_USAGES|CURRENTLY_USED|LAST_USAGE_DATE|DESCRIPTION |FEATURE_INFO
-----------------------------|--------------- |--------------|---------------|------------|
Oracle Utility Datapump (Export) | 3|TRUE |2020.02.09_06.46.38|Oracle Utility Datapump (Export) has been used.|Oracle Utility Datapump (Export) invoked: 24 times, compression used: 0 times, e
But the query which I am using is poviding the advanced compression
Advanced Compression |Oracle Utility Datapump (Export)|NO_CURRENT_USAGE 2020.02.09_06.46.38|1571512636|11.2.0.4.0 | 3| 5|TRUE|2020.01.26_04.42.05|2020.02.09_06.46.38|compression used: 0 times
[Edit MC: MOS query removed]
[Updated on: Sun, 09 February 2020 00:37] by Moderator Report message to a moderator
|
|
|
Re: Disable Oracle Feature [message #679133 is a reply to message #679132] |
Sun, 09 February 2020 00:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
I told you to NOT post copyrighted materials.
And I told you (twice) that there is no problem.
If you don't understand the query you use and its output then don't use it.
|
|
|