Cannot add data file to Information Manager 5.1
Voted best answer
Searching online for "oracle 11 smallfile tablespace max size" does not make me feel you have reached any hard limit, yet. Please verify this filtering for the exact version in use.
How many events are you storing in the message log of this IM? Total limit per IM is 12 million.
SELECT COUNT(*) FROM OPS$OCSHIS.MSGxxx;
Has the IM internal truncation/housekeeping failed (which would argue against further extension of tablespace)? I can't say if a "hsDBMaint -checkDB" would find out if MSGATTRSxxx have orphan rows (not linked to any row in MSGxxx) wasting space.
Adding additional datafiles is rather easy with SQL CLI (you can peek at the job in another IM to see the exact syntax used by IM; I believe its output somewhere before you hit apply) but I can't say if it is the correct thing to do in this situation.
Filing a support case might be advisable...
When I un-ticked ‘Autoextend’ for the existing datafiles I could add a new one.
I haven't done other checks as yet, but the future growth of the Index tablespace will be monitored.