Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
 
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.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB