My Oracle Support Banner

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


 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



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.