Oracle | DBMS_HS

Oracle DBMS_HS_PARALLEL 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 Heterogeneous Services Bulk Load

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
Exceptions
no_dblink_num	NUMBER	-24277
no_remote_table_num	NUMBER	-24278
no_view_num	NUMBER	-24279

Dependencies

DBMS_ASSERT	HSBLKVALARY	HS_PART_OBJ
DBMS_HS_PARALLEL_METADATA	HS_BULK_SEQ	HS_SAMPLE_OBJ
HSBLKNAMLST	HS_PARTITION_OBJ	PLITBLM

Documented Yes

Exceptions

Error Code	Reason
-24277	no_dblink exception
-24278	no_remote_table
-24279	no_view

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmshsld.sql
{ORACLE_HOME}/rdbms/admin/prvthsld.plb

Subprograms

CREATE_OR_REPLACE_VIEW	DROP_VIEW	TABLE_SAMPLING
CREATE_TABLE_TEMPLATE	LOAD_TABLE

CREATE_OR_REPLACE_VIEW

Undocumented dbms_hs_parallel.create_or_replace_view( remote_table IN VARCHAR2, database_link IN VARCHAR2, oracle_view IN VARCHAR2 := NULL, parallel_degree IN INTEGER := NULL);

TBD

CREATE_TABLE_TEMPLATE

Undocumented dbms_hs_parallel.create_table_template( remote_table IN VARCHAR2, database_link IN VARCHAR2, oracle_table IN VARCHAR2 := NULL, create_table_template_string OUT VARCHAR2);

TBD

DROP_VIEW

Undocumented dbms_hs_parallel.drop_view(oracle_view IN VARCHAR2);

TBD

LOAD_TABLE

Undocumented dbms_hs_parallel.load_table( remote_table IN VARCHAR2, database_link IN VARCHAR2, oracle_table IN VARCHAR2 := NULL, truncate IN BOOLEAN := TRUE, parallel_degree IN INTEGER := NULL, row_count OUT NUMBER);

TBD

TABLE_SAMPLING

Undocumented dbms_hs_parallel.table_sampling( remote_schema IN VARCHAR2, remote_table_name IN VARCHAR2, database_link IN VARCHAR2, hs_remote_tab_typ IN VARCHAR2, p_degree IN NUMBER, row_count IN NUMBER, ora_user IN VARCHAR2, oracle_table_name IN VARCHAR2, pt_col_names IN sys.hsblknamlst pt_col_types IN sys.hsblknamlst col_names IN sys.hsblknamlst col_types IN sys.hsblknamlst);

TBD