ORA-27092: skgfofi: size of file exceeds file size limit of the process

ERROR at line 2:
ORA-01116: error in opening database file 34
ORA-01110: data file 34: '/data/xxx/02/oradata/DM_IDX_1_01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process
Additional information: 131071
Additional information: 202241

Cause:

The account that is used to run the stored procedure or simple SQL query could yield the above errors. The issue was related to the ULIMIT set to the user account

Solution:

Have UNIX administrator reset the ULIMIT to a higher value or "unlimited"