Need to add a new data file needs to be added to the table space.
The datafile has reached the Oracle 32 GB size limit.
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.
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)"