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.
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