Oracle Common error codes



ORA-01650: unable to extend rollback segment NAME by NUM intablespace NAME Cause: The ORACLE error was caused by rollback table space, which is the most common data administrators ORACLE ORACLE error message.When the user is doing a very large data manipulation led to the current lack of rollback, the rollback segments can be assigned table space with a full and can not be distributed, the above error occurs.

ORA-01652: unable to extend temp segment by num in tablespace name Cause: ORACLE temporary segment table space, because the ORACLE always try to allocate contiguous space, one can be allocated but not enough space or there will be discontinuous distribution of the abovephenomenon.

ORA-01628: max # of extents num reached for rollback segment num Cause: This error is usually a rollback and a table space has reached MAXEXTENTS parameter limits.Note that this is not the rollback segments MAXEXTENTS or table space limits of the hardware, the hardware limit depends on the database is created in the init.ora file specified DB_BLOCK_SIZE parameter.

ORA-01688: unable to extend table name.name partition NAME by NUM in tablespace NAME Cause: The specified tablespace space has been occupied by full, can not be extended.