Oracle 18cR3 DBMS_RULE_EXP_RS

Oracle DBMS_RULE_EXP_RS_INTERNAL Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBMS_RULE_EXP_RULE_SETS	NOEXP$	RULE_MAP$
DBMS_RULE_EXP_UTL	OBJ$	RULE_SET$
DBMS_SYS_ERROR	RULE$	USER$
DBMS_ZHELP

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtreut.plb

Subprograms

I_CREATE_EXP

I_GRANT_EXP

I_GRANT_SYSPRIVS_EXP

I_CREATE_EXP

Undocumented dbms_rule_exp_rs_internal.i_create_exp( objid IN NUMBER, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

I_GRANT_EXP

Undocumented dbms_rule_exp_rs_internal.i_grant_exp( objid IN NUMBER, isdba IN BINARY_INTEGER, grantor OUT VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

I_GRANT_SYSPRIVS_EXP

Undocumented dbms_rule_exp_rs_internal.i_grant_sysprivs_exp( new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

 retVal VARCHAR2(128);

 outVal BINARY_INTEGER;

      BEGIN

  retVal := dbms_rule_exp_rs_internal.i_grant_sysprivs_exp(outVal);

  dbms_output.put_line(TO_CHAR(retVal));

  dbms_output.put_line(outVal);

      END;

      /

      
      SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, 
      '"AQ_ADMINISTRATOR_ROLE"',TRUE);