Oracle DBMS_HS_PARALLEL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_PARALLEL_METADATA
DBMS_HS_PASSTHROUGH
DBMS_HS_UTL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx