Archive

Archive for the ‘ora-errors’ Category

ora-01653 unable to extend table in tablespace

August 27, 2011 Leave a comment

I got the below error message when i tried to insert a record into table.

ora-01653 unable to extend table in tablespace

Now we need to query the dba_data_files tables and see autoextend is off or not.

select file_name,tablespace_name,autoextensible from dba_data_files
where tablespace_name=’TBS_DS_OWNER’

If value of “AUTOEXTENSIBLE” column is NO, check how many bytes are used by Oracle and max size of the tables space by using following queries.

how many bytes used by oracle:

SELECT
tablespace_name,
SUM(bytes/1024/1024)
FROM
dba_segments
GROUP BY
tablespace_name;

Max  size of the tablespace:

select tablespace_name,sum(bytes)/1024/1024 “Max Size in MB” from dba_data_files
where tablespace_name=’TBS_DS_OWNER’
group by tablespace_name

If the difference between this value and max size value is small then we need to add datafile or increse the size of the the datafile to insert more records.

Thanks

Categories: ora-errors
%d bloggers like this: