Database space allocation problems

Occasionally, import and export jobs fail because of insufficient space allocated for tables, indexes, rollback segments, and temporary segments.

Symptoms

If the rollback segment is full or the rollback segment table space is full, an error message is recorded in the alert log file that is similar to the following error message:

ORA-1650: unable to extend rollback segment RBS8 by 512 in
tablespace RBS.
Failure to extend rollback segment 9 because of 1650 condition
FULL status of rollback segment 9 set.

Resolving the problem

Make sure that you have enough free space in the table spaces. For larger jobs, more space might be needed in rollback and temporary segments. Check the alert log file of the database every day to see whether there are any errors generated related to space issues in the database.