Big Data Sql3.1 and Higher Table Error "ORA-23362: invalid user"

(Doc ID 2330981.1)

Last updated on DECEMBER 24, 2017

Applies to:

Oracle Big Data SQL - Version 3.1.0 and later
Linux x86-64

Symptoms

 The following Big Data SQL (BDS) table error is raised  BDS 3.1:

SQL> /
BEGIN DECLARE DDLtxt clob; BEGIN dbms_hadoop.create_extddl_for_hive('<cluster>', '<dbname>', '<hive table name>',TRUE, 'user1.<table>', TRUE, DDLtxt); END; END;
*
ERROR at line 1:
ORA-23362: invalid user
ORA-06512: at "SYS.DBMS_HADOOP", line 66
ORA-06512: at line 1

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms