Oracle | DBMS

Oracle DBMS_REPCAT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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.