My Oracle Support Banner

Big Data Sql3.1 and Higher Table Error "ORA-23362: invalid user" (Doc ID 2330981.1)

Last updated on JANUARY 22, 2020

Applies to:

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


NOTE: In the examples that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

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_NAME>', '<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.