AR-ARRGTA: ORA-01653 Unable to Extend AR.AR_JOURNAL_INTERIM_ALL

Steps to reproduce:

Submit Request “Journal Entries Report

Request Log shows:

‘ARJIRA’

AR-ARRGTA: -1653 ORA-01653 Unable to extend table AR.AR_JOURNAL_INTERIM_ALL

Solution:

DocID: 151994.1

Check which tablespace is holding the problem table:

SELECT * FROM DBA_TABLES WHERE OWNER =’AR’ AND TABLE_NAME LIKE ‘AR_JOURNAL_INTERIM_ALL’

Check the size of tables_space, in this case its APPS_TS_NOLOGGING

SELECT file_name, tablespace_name, bytes/1024/1024 sizeMB FROM dba_data_files
WHERE tablespace_name  LIKE ‘APPS_TS_NOLOGGING’


Then resize

ALTER DATABASE  DATAFILE ‘/d/oracle/prod2data/a_nolog01.dbf’ RESIZE 1G;

Run the request and validate if everything is OK.

Doc ID: 151994.1 Overview Of ORA-01653: Unable To Extend Table %s.%s By %s In Tablespace %s

Advertisements

About this entry