Eventually the Database Monitor window in OneClick will display a message stating that NH_TEMP01.DBF is approaching file size limit of 32GB. Even with the auto-extend option set as YES, once any datafile reaches 32GB in size it cannot be extended, and a new file must be created. The NH_TEMP tablespace is different from other tablespaces in the eHealth database in that instead of adding a new file, we can remove and recreate this file without a negative impact to the system.
This knowledge document explains the procedure to recreate the NH_TEMP01 datafile, and is valid for all versions of eHealth from 5.7 and up.
Please follow the steps below to delete the current NH_TEMP01.dbf file (or whatever variation on the name you have on your system, such as NH_TEMP01a.dbf) and recreate it. The notation <fileName> indicates the full path and name of your temp file; for example, 'd:/oradata/eHealth/nh_temp01.dbf (including the single quotes). Also note that we recommend that you have a good database backup before performing the steps listed.
Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements