Category: Databases

ORA-00051: time-out occurred while waiting for resource

Oracle/PLSQL: ORA-00051 Learn the cause and how to resolve the ORA-00051 error message in Oracle. Description When you encounter an ORA-00051 error, the following error message will appear: ORA-00051: time-out occurred while waiting for resource Cause You were waiting for a resource and you timed out. This may have been caused by an Oracle instance […]

ORA-00028: your session has been killed

Oracle/PLSQL: ORA-00028 Learn the cause and how to resolve the ORA-00028 error message in Oracle. Description When you encounter an ORA-00028 error, the following error message will appear: ORA-00028: your session has been killed Cause Your session has been killed by a privileged user (such as a DBA). Resolution The option(s) to resolve this Oracle […]

ORA-00020: maximum number of processes num exceeded

Oracle/PLSQL: ORA-00020 Learn the cause and how to resolve the error message in Oracle. Description When you encounter this error, the following error message will appear: ORA-00020: maximum number of processes num exceeded Cause You tried to execute a statement that requested a resource. Since the maximum number of processes have been reached, Oracle will not […]

ORA-00002: error in writing to export file

Oracle’s error code: ORA-00002 Description When you encounter an ORA-00002 error, the following error message will appear: ORA-00002: error in writing to export file Cause Export could not write to the export file, probably because of a device error. This message is usually followed by a device message from the operating system. Resolution Take appropriate […]

ORA-00001: unique constraint (constraint_name) violated

Oracle’s error code: ORA-00001   Description When you encounter an ORA-00001 error, the following error message will appear: ORA-00001: unique constraint (constraint_name) violated Cause You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. Resolution The option(s) to resolve this Oracle error […]