Oracle | DBMS_PQ

Oracle DBMS_PQ_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 and following its action using 10046 and 10053 traces did not provide sufficient clarity to know how and when it is expected to function.

AUTHID CURRENT_USER

Dependencies

DBMS_STANDARD

V$DATABASE

Documented No

Exceptions

Error Code	Reason
ORA-20000	Could not create database link: sys-hub

First Available 12.2

Security Model Owned by SYS with no privileges granted

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

CREATE_DB_LINK_FOR_HUB

Undocumented dbms_pq_internal.create_db_link_for_hub;

exec dbms_pq_internal.create_db_link_for_hub;

      

      PL/SQL procedure successfully completed.