Oracle | DBMS_DEFER_IMPORT

Oracle DBMS_DEFER_IMPORT_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

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/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;

      

      QUEUE_EXPORT_CHECK

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

QUEUE_IMPORT_CHECK

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

SELECT dbms_utility.port_string;

      

      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.