| Disable Oracle Feature [message #679088] |
Mon, 03 February 2020 09:07  |
 |
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  |
|
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 |
|
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 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
