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.

No comments:

Post a Comment

Popular Posts