Oracle | DBMS_RULE

Oracle DBMS_RULE_EXIMP Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Import utilities supporting the evaluation of event rule sets

AUTHID DEFINER

Data Types All re$ data types used by the package are owned by SYS

Dependencies

DBA_EVALUATION_CONTEXTS	DBMS_AQADM_VAR	DBMS_SYSTEM
DBA_RULES	DBMS_RULEADM_INTERNAL	RE$TABLE_ALIAS
DBA_RULE_SETS	DBMS_RULE_ADM	RE$TABLE_ALIAS_LIST

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to SYSTEM with GRANT OPTION and to the AQ_ADMINISTRATOR_ROLE, EXECUTE_CATALOG_ROLE, EXP_FULL_DATABASE, and IMP_FULL_DATABASE roles.

Source {ORACLE_HOME}/rdbms/admin/dbmsread.sql

Subprograms

IMPORT_RULE

IMPORT_RULE_SET

IMPORT_RULE

Undocumented dbms_rule_eximp.import_rule( rs_schema IN VARCHAR2, rs_name IN VARCHAR2, rule_name IN VARCHAR2, cond IN VARCHAR2);

TBD

IMPORT_RULE_SET

Undocumented dbms_rule_eximp.import_rule_set( rs_schema IN VARCHAR2, rs_name IN VARCHAR2, basetab_schema IN VARCHAR2, basetab_name IN VARCHAR2, rulestab_schema IN VARCHAR2, rulestab_name IN VARCHAR2);

TBD