Oracle | DBMS

Oracle DBMS_REPCAT Version 23c

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 Undocumented this package has been associated with Advanced Replication. The two objects in this package appear to be around to support legacy import-related functionality.

The Overload 1 demo, below, I just put in invalid strings to see what would happen. It didn't do anything obvious and didn't raise an exception. The only way to force an exception seems to be using a non-Boolean value for the "master" parameter.

AUTHID DEFINER

Dependencies

STANDARD (only)

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to IMP_FULL_DATABASE

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

Subprograms

REPCAT_IMPORT_CHECK

REPCAT_IMPORT_REPSCHEMA

REPCAT_IMPORT_CHECK

Undocumented

Overload 1 dbms_repcat.repcat_import_check( gname IN VARCHAR2, master IN BOOLEAN, gowner IN VARCHAR2);

exec dbms_repcat.repcat_import_check('ABCDE', TRUE, 'ZZYZX');

      

      PL/SQL procedure successfully completed.

Overload 2 dbms_repcat.repcat_import_check;

exec dbms_repcat.repcat_import_check;

      

      PL/SQL procedure successfully completed.

REPCAT_IMPORT_REPSCHEMA

Undocumented dbms_repcat.repcat_import_repschema;

exec dbms_repcat.repcat_import_repschema;

      

      PL/SQL procedure successfully completed.