Oracle DBMS_LOGREP_UTIL_INVOK
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 Internal support for log file replication utilities
AUTHID CURRENT_USER
Dependencies
DBMS_APPLY_ADM DBMS_LOGREP_LIB DBMS_STREAMS_ADM_UTL_INVOK
DBMS_APPLY_ADM_INTERNAL DBMS_LOGREP_UTIL DBMS_STREAMS_MC
DBMS_APPLY_ADM_IVK DBMS_PRIV_CAPTURE DBMS_STREAMS_MESSAGING
DBMS_APPLY_HANDLER_ADM DBMS_PROPAGATION_INTERNAL DBMS_STREAMS_MT
DBMS_CAPTURE_ADM DBMS_RECO_SCRIPT_INVOK DBMS_STREAMS_TABLESPACE_ADM
DBMS_CAPTURE_ADM_INTERNAL DBMS_STREAMS_ADM DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_IVK DBMS_STREAMS_ADM_IVK DBMS_XSTREAM_ADM_UTL
DBMS_FILE_GROUP DBMS_STREAMS_ADM_UTL DBMS_XSTREAM_UTL_IVK
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvthlut.plb
Subprograms
 
CHECK_BECOME_USER_PRIVILEGE
Undocumented dbms_logrep_util_invok.check_become_user_privilege(
user_name IN VARCHAR2,
check_dv  IN BOOLEAN);
exec dbms_logrep_util_invok.check_become_user_privilege('UWCLASS', FALSE);
 
CHECK_DV_STREAMS_ADMIN
Undocumented dbms_logrep_util_invok.check_dv_streams_admin(user_name IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF dbms_logrep_util_invok.check_dv_streams_admin('UWCLASS') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
 
CHECK_PDB_ACCESS (new 18.1)
Not sure what it is supposed to do but it doesn't seem to do anything even if you give it an invalid PDB name or a name that could never be valid as show at right. dbms_logrep_util_invok.check_pdb_access(contaier_in VARCHAR2);
exec dbms_logrep_util_invok.check_pdb_access('PDBDEV');

exec dbms_logrep_util_invok.check_pdb_access('PDB DEV');
 
GET_OBJECT_NAME (new 18.1)
Undocumented dbms_logrep_util_invok.get_object_name(
object_name   IN  VARCHAR2,
canon_owner   OUT VARCHAR2,
canon_name    OUT VARCHAR2,
canon_schema  IN  VARCHAR2,
allow_3X_iden IN  BOOLEAN);
DECLARE
 oOwner VARCHAR2(30);
 oName  VARCHAR2(30);
BEGIN
  dbms_logrep_util_invok.get_object_name('SALES', oOwner, oName, 'C##SH', FALSE);
  dbms_output.put_line(oOwner);
  dbms_output.put_line(oName);
END;
/
C##SH
SALES

Related Topics
Built-in Functions
Built-in Packages
DBMS_LOGREP_DEFPROC_UTL
DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
What's New In 12cR2
What's New In 18cR3

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-2019 Daniel A. Morgan All Rights Reserved