Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching, Zero-Downtime Upgrade, GoldenGate

Oracle Exadata ,Oracle ODA, Oracle ZDLRA


当前位置: 首页 » 技术文章 » AODU

aodu(At Oracle Database Utility)之unwrap

unwrap函数,是把加密的package、procedure、function做解密,适用版本10g,11g,12c

[oracle@db1 ~]$ ./aodu


AT Oracle Database Utility,Release 1.1.0 on Tue Jun 14 00:01:49 2016
Copyright (c) 2014, 2015, Robin.Han.  All rights reserved.
http://ohsdba.cn
E-Mail:375349564@qq.com

AODU> unwrap /u01/oracle/product/121/rdbms/admin/prvtstat.plb dbms_stats.sql

AODU> exit

[oracle@db1 ~]$ ls -l dbms_stats.sql
-rw-r--r-- 1 oracle oinstall 1380807 Jun 14 00:02 dbms_stats.sql

[oracle@db1 ~]$ head -20 dbms_stats.sql
CREATE OR REPLACE TYPE BODY wri$_rept_optstats IS




  OVERRIDING MEMBER FUNCTION GET_REPORT(REPORT_REFERENCE IN VARCHAR2)
  RETURN XMLTYPE
  IS
    COMPONENT_NAME    VARCHAR2(30);
    REPORT_NAME       VARCHAR2(30);
    PARAMS            DBMS_REPORT.REF_STRING_IDSPEC;
    SINCE             TIMESTAMP WITH TIME ZONE;
    UNTIL             TIMESTAMP WITH TIME ZONE;
    AUTO_ONLY         BOOLEAN := FALSE;
    DETAIL_LEVEL      VARCHAR2(10);
    LATESTN           NUMBER := NULL;
    CONTAINER_IDS_TXT VARCHAR2(32767);
    CONID_TAB         DBMS_UTILITY.NUMBER_ARRAY;
    START_IX          NUMBER;
    CONID_TXT         VARCHAR2(100);
    CONID             NUMBER := NULL;     CONID_IX          NUMBER := 1; [oracle@db1 ~]$ 


关键词:aodu 

相关文章

aodu(At Oracle Database Utility)之optim
aodu(At Oracle Database Utility)之asm(二)
aodu(At Oracle Database Utility)之asm(一)
aodu(At Oracle Database Utility)之rac(二)
aodu(At Oracle Database Utility)之rac(一)
aodu(At Oracle Database Utility)之ora600
aodu(At Oracle Database Utility)之asmdisk
aodu(At Oracle Database Utility)之unwrap
aodu(At Oracle Database Utility)之rdba
aodu(At Oracle Database Utility)之drux
aodu(At Oracle Database Utility)之time
aodu(At Oracle Database Utility)之odlog
Top