Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - ORA-01950: no privileges on tablespace


Copy link to this message
-
ORA-01950: no privileges on tablespace
Raj Hadoop 2013-05-21, 19:26
 
I am setting up a metastore on Oracle for Hive. I executed the script hive-schema-0.9.0-sql file too succesfully.
 
When i ran this
hive > show tables;
 
I am getting the following error.
 
ORA-01950: no privileges on tablespace
 
What kind of Oracle privileges are required (Quota wise for Hive) for hive oracle user in metastore? Please advise.