Oracle DBMS_BDSQL
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Big Data Cluster Access Utility
AUTHID CURRENT_USER
Constants
Name Data Type Value
General
HADOOP_USER_MAX_LEN PLS_INTEGER 30
NAMESPACE_MAX_LEN PLS_INTEGER 30
Dependencies
     
Documented No
Exceptions
Error Code Reason
ORA-20865 INVALID_USERNAME
ORA-20886 AMBIGUOUS_ROW
ORA-20887 HADOOP_USER_TOO_LONG
ORA-20888 NAMESPACE_TOO_LONG
ORA-20889 NOTHING_TO_REVOKE
ORA-20890 NO_ROWS_FOUND
ORA-20891 INVALID_NAME_ASSERT
ORA-20892 INVALID_NAME_FOR_US
ORA-20893 NULL_SYSCTX_PARM_HADOOP_PASSED
ORA-20894 ROLE_PRIV_ERR
ORA-20895 DUPLICATE_ROW
ORA-20896 INVALID_USERENV_ATTRIBUTE
ORA-20897 NULL_FOURTH_PARAMETER_PASSED
ORA-20898 NULL_CURRENT_DB_USER_PASSED
ORA-20899  NULL_CLUSTER_NAME_PASSED
ORA044003 ASSERT_INVALID_NAME
First Available 19c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsbdcluacc.sql
Subprograms
 
ADD_USER_MAP (new 19c)
Add a Big Data Cluster Acccess user map dbms_bdsql.add_user_map(
cluster_name                IN VARCHAR2 DEFAULT '[DEFAULT]',
current_database_user       IN VARCHAR2,  -- NOT NULL
syscontext_namespace        IN VARCHAR2,  -- DEFAULT NULL
syscontext_parm_hadoop_user IN VARCHAR2); -- NOT NULL
TBD
 
REMOVE_USER_MAP (new 19c)
Remove a Big Data Cluster Acccess user map dbms_bdsql.remove_user_map(
cluster_name          IN VARCHAR2 DEFAULT '[DEFAULT]',
current_database_user IN VARCHAR2); -- NOT NULL
TBD

Related Topics
Built-in Functions
Built-in Packages
What's New In 18cR3
What's New In 19cR2

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-2019 Daniel A. Morgan All Rights Reserved