Oracle PRVT_COMPRESS
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Undocumented support for likely for Advanced and/or Hybrid Columnar Compression
AUTHID DEFINER
Dependencies
DBA_SEGMENTS TAB$ TABSUBPART$
DBMS_COMPRESSION TABPART$ TS$
SEG$    
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtcmpr.plb
Subprograms
 
GET_ARCH_COMP
Undocumented prvt_compress.get_arch_comp(
dobjno  IN NUMBER,
dictobj IN NUMBER,
objtype IN NUMBER)
RETURN BOOLEAN;
conn / as sysdba

CREEATE TABLE comp_all_oper
COMPRESS FOR ALL OPERATIONS AS
SELECT * FROM tab$;

SQL> SELECT o.obj#, o.dataobj#, o.type#
   2 FROM obj$ o
   3 WHERE o.name = 'COMP_ALL_OPER';

      OBJ#   DATAOBJ#      TYPE#
---------- ---------- ----------
     92954      92954          2

BEGIN
  IF prvt_compress.get_arch_comp(92954,92954,2) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.PRVT_COMPRESS", line 27
ORA-06512: at line 2
 
GET_TS_NUM
Undocumented prvt_compress.get_ts_num(
ownname  IN VARCHAR2,
tabname  IN VARCHAR2,
partname IN VARCHAR2,
objtype  IN VARCHAR2)
RETURN NUMBER;
DECLARE
 retVal NUMBER;
BEGIN
  retVal := prvt_compress.get_ts_num('SYS', 'COMP_ALL_OPER', NULL, 'TABLE');
  dbms_output.put_line(TO_CHAR(retVal));
END;

Related Topics
DBMS_COMPRESSION
PRVT_COMPRESSION
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved