Error: ORA-01536: Space Quota Exceeded For 'APPS_TS_TX_IDX or APPS_TS_MEDIA

Cause:

The issue is caused by a missing APPS and/or APPLSYS space quota in table dba_ts_quotas. This is justified by the fact that any of the following query returns no records, confirming that the APPS and/or APPLSYS user has no quota on the tablespace APPS_TS_TX_IDX:

select * from dba_ts_quotas
where username in ('APPS','APPLSYS')
and tablespace_name = 'APPS_TS_TX_IDX';

Solution:

1. Connect to SQL Plus

2. Execute the following command to give unlimited quota on the problematic tablespace for the user (APPS and/or APPLSYS) that returned no rows when querying dba_ts_quotas.

If APPS user returned no rows execute the following command:

alter user apps quota unlimited on APPS_TS_TX_IDX;

If APPLSYS user returned no rows execute the following command:

alter user applsys quota unlimited on APPS_TS_TX_IDX;