While restoring a dump to my Oracle database, I was hit by an error which related to table quota. I have verified the table space which showing enough storage and still I’m getting such error.
Error at Command Line:1 Column:0
SQL Error: ORA-01536: space quota exceeded for tablespace ‘TEMPLE’
01536. 00000 – “space quota exceeded for tablespace ‘%s'”
*Cause: The space quota for the segment owner in the tablespace has
been exhausted and the operation attempted the creation of a
new segment extent in the tablespace.
*Action: Either drop unnecessary objects in the tablespace to reclaim
space or have a privileged user increase the quota on this
tablespace for the segment owner.
This is something related to user permission against a tables space . The following command will solve the issue.
For testing I use to create a table,
and got the response
Then I dropped it
The following command would help you to extend the table space.
ADD DATAFILE '/usr/lib/oracle/xe/oradata/XE/mytbl_space_02.dbf'
This will extend the tablespace to 900Mb by adding new file to the existing data file.