Oracle | DBMS_REPCAT

Oracle DBMS_REPCAT_MIG 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 These procedures are called during migration of V7.3.x to V8.0.2 using the export/import utilities: the import utility will call it
They are private functions to be released in PL/SQL binary form and are shared by a snapshot and master partitions.

Why they are still hanging around in version 20c is a total mystery given that every other piece of Advanced Replication has been dropped from the product.

AUTHID DEFINER

Dependencies

STANDARD (only)

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the IMP_FULL_DATABASE role

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

Subprograms

After a V8 import, this procedure is called to clean up any V7 replication objects (mlog$_%, triggers) that require modification

Overload 1 dbms_repcat_mig.cleanup_import(dump_version IN NUMBER);

exec dbms_repcat_mig.cleanup_import(23.2);

      

      PL/SQL procedure successfully completed.

After a full replicated db import, this routine is invoked to perform any necessary cleanup

Overload 2 dbms_repcat_mig.cleanup_import(expseal IN VARCHAR2);

TBD

POST_IMPORT

Called after doing a full import of a database with replicated data dbms_repcat_mig.post_import;

exec dbms_repcat_mig.post_import;

      

      PL/SQL procedure successfully completed.

PRE_IMPORT

Called before doing a full import of a database with replicated data dbms_repcat_mig.pre_import;

exec dbms_repcat_mig.pre_import;

      

      PL/SQL procedure successfully completed.