Java @ Desk: Oracle | Java at your desk

Unable to extend table by in tablespace ORA-06512

Unable to extend table by in tablespace ORA-06512

The issue occurs while writing the new record into the database when there is no sufficient storage available. The storage capacity of data file mentioned in the exception log is causing the issue.

One can set the AUTOEXTEND to true in the database, otherwise Oracle will not auto-increase the storage of the data file.

In order to manually extend the storage capacity, follow the steps

1) Find the location and data size of the data files that is causing the issue
SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = '<TABLESPACE_NAME>';


2) Alter the size of the data file from step 1
ALTER TABLESPACE <TABLESPACE_NAME> ADD DATAFILE '<FILE_NAME>' SIZE 200M;