Oracle | DBMS_DEFER_IMPORT

Oracle DBMS_DEFER_IMPORT_INTERNAL 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 Undocumented but believed to be part of Advanced Replication which was dropped from the product. Why this particular package remains is not known but based on the security model it appears related to the Import Utility and/or DataPump.

AUTHID DEFINER

Dependencies

Only STANDARD

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/prvtbrmg.plb

Subprograms

DROP_PROPAGATOR_CASCADE

QUEUE_EXPORT_CHECK

QUEUE_IMPORT_CHECK

DROP_PROPAGATOR_CASCADE

Undocumented dbms_defer_import_internal.drop_propagator_cascade(dropped_user IN VARCHAR2);

exec dbms_defer_import_internal.drop_propagator_cascade('C##DROPME');

      

      PL/SQL procedure successfully completed.

QUEUE_EXPORT_CHECK

Undocumented dbms_defer_import_internal.queue_export_check RETURN VARCHAR2;

SELECT dbms_defer_import_internal.queue_export_check

      FROM dual;

QUEUE_IMPORT_CHECK

Undocumented dbms_defer_import_internal.queue_import_check( global_name IN VARCHAR2, port_string IN VARCHAR2);

SELECT dbms_utility.port_string FROM dual;

      

      PORT_STRING

      ---------------------

      x86_64/Linux 2.4.xx

      

      exec dbms_defer_import_internal.queue_import_check('TEST21DB', dbms_utility.port_string);

      

      PL/SQL procedure successfully completed.