Getting error ORA-01653: unable to extend table

Document ID : KB000023764
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Need to add a  new data file needs to be added to the table space. 

Cause:

The datafile has reached the Oracle 32 GB size limit.

Resolution: 

To determine which tablespace needs a data file added to it run the below command located in $NH_HOME/bin/sys/


nhiShowDbSpace all -wider.


Then review the Datafile Report section and find the file that is at 32G Total 0% free. Also note the directory.  The likely culprit is NH_DATA01 but not always  

An example output from nhManageDbSpace command showing a full datafile in the NH_DATA01 tablespace. 

 

|           | /eh_db/oradata/EHEALTH/NH_DATA01a.dbf                                            |  31G |  0% |

 

To add a datafile to the tablespace identified above use the nhManageDbSpace command using the path and tablespace identified above.

nhManageDbSpace  -add -newPath /eh_db/ -tablespace NH_DATA01 -size 100

 

Note: if the file is NH_DATA01a.dbf the tablespace will be just NH_DATA01. Oracle will add the letter and .dbf extension. 

 

Additional Information: 

These errors may be seen in the system.log file also. 

"Unable to add network element' data to the database" and 

 

"Unable to execute 'CREATE TABLE nh_stats0_nnnnnnn MONITORING LOGGING PTCTFREE 10 PCTUSED 75 TABLESPACE NH_DATA01 AS SELECT * FROM NH_RLP_STATS '(ORA-01658: unable to create INITAL extent for segment in tablespace N)"