Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-31630 – a job name is required to attach a job for user string

Oracle Database Error Code ORA-31630 Description :

a job name is required to attach a job for user string

Error Cause:

No job name was supplied for an attach and the user has either no jobs executing or mutiple jobs executing.

How to Solve :

Provide a job name for attach to use in selecting an executing job, or to use for restarting a stopped job.