Showing posts with label Solution for Oracle Error in IBM Sterling. Show all posts
Showing posts with label Solution for Oracle Error in IBM Sterling. Show all posts

Tuesday, June 25, 2019

[SOLVED] - ORA-01653: unable to extend table SELON.YFS_WAVE_AUDIT by 8192 in tablespace PROD_DATA

ORA-01653: unable to extend table SELON.YFS_WAVE_AUDIT by 8192 in tablespace PROD_DATA

Reason:
Total number of records already reached its maximum limit.

select count(*) from YFS_WAVE_AUDIT
where createts < to_date('2016-05-01', 'YYYY-MM-DD')

i.e, 7758532 records

Example:
8891523 records in YFS_WAVE_AUDIT table now without any date condition.

Solutions:
1. We need to purge the specific table
(or)

2. If it is Development Server, then delete the old records from YFS_WAVE_AUDIT table.

delete from YFS_WAVE_AUDIT
where createts < to_date('2016-05-01', 'YYYY-MM-DD')

Commit it

If you try after delete the old records, Instance will work fine without any issue.

Popular Posts