Hi
I am new to ORacle. I installed Oracle XE latest version on my laptop. I created a table emp. But when i try to insert, i get error-ORA-01950: no privileges on tablespace 'USERS'.
I checked other discussions and they suggested to use alter statement.
You cannot insert data because you have a quota of 0 on the tablespace. To fix this, run
ALTER USER <user> quota unlimited on <tablespace name>;
.
However i am not sure on my tablespace name. How can i run this query
I also tried to find tablespace name with query:
select tablespace_name from all_tables where owner='richa' and table_name='emp';
But it throws an error- no row selected. without tablespace name, i cannot alter the user priveleges. And without proper priveleges, i cannot insert in the database.
I am totally confused, can someone help me with this issue.
ou cannot insert data because you have a quota of 0 on the tablespace. To fix this, run
ALTER USER <user> quota unlimited on <tablespace name>;