ORA-01950: no privileges on tablespace

[Raj Hadoop]

 
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.