Oracle Common error Codes

oracle| error ora-01650:unable to extend rollback segment name by NUM intablespace name


Cause: The Oracle error described above is caused by a lack of space in the rollback segment, which is also the most common Oracle error message for Oracle data administrators. This error occurs when the user is doing a very large data operation that causes the existing rollback segment to be insufficient so that the allocated rollback segment table space is full and cannot be allocated.

Ora-01652:unable to extend temp segment by num in Tablespace name

Reason: There is not enough space in the Oracle Temporary segment table because Oracle always allocates contiguous space as much as possible, as long as there is not enough unallocated space or the distribution is discontinuous.

Ora-01628:max # of extents Num reached for rollback segment num

Cause: This error is usually a rollback segment and a table space has reached the limit set by the maxextents parameter. Note that this maxextents is not the hardware limit for the rollback segment or table space, and the hardware limit depends on the value of the Db_block_size parameter specified in the Init.ora file when the database was created.

Ora-01688:unable to extend table Name.name partition name by NUM in Tablespace name

Reason: The specified tablespace space has been occupied and cannot be extended.