The first line of the error message (ie: ORA-06502) indicates the error that occurred, while the second line of the error message (ie: ORA-06512) indicates that the error occurred at line 5 of the PLSQL code. In this example, you’ve tried to assign a 3 digit number to a variable called v_number…

Why am I getting an ora-06598 error with Oracle data pump imports?

Customers have reported getting an “ORA-06598 error: insufficient INHERIT PRIVILEGES privilege” error with Oracle Data Pump imports after moving to Oracle 12c when running the import as the SYS or SYSTEM user.

What does ora-6512 mean?

ORA 6512 does not indicate the actual error, but the line number of the unhandled error in the PLSQL code. ORA-6512 will typically appear in a message stack in which the preceding message names the reason for the error, such as in the following example: 1) Fix the condition that is causing the unhandled error.

What does the error code ora-01422 mean?

The ‘ORA-01422’ code is the actual error code you need to be looking at. The ORA-06512 is just the general error code. The second line tells you where the error is occurring.

When is an ora-01861 triggered?

So judging by this, it should be pretty clear that often an ORA-01861 is triggered when a literal has been entered that fails to follow a format string. Perhaps you entered a date literal as ‘06/26/2015’ into a table with a date format string of ‘YYYY-MM-DD’.

What is the ora-01422 error?

The latter, which the ORA-01422 can most aptly identify with, concerns a user-initiated mistake resulting from either a typo or a misunderstanding of how Oracle functions may work. So what syntax mistakes are causing the ORA-01422 error? Why are they a problem? And most importantly, how can we fix it?

Why did ora-01653 fail to add a datafile?

Cause: Failed to allocate an extent for table segment in tablespace. files to the tablespace indicated. Cause: Failed to allocate extent for index segment in tablespace. files to the specified tablespace. When you are notified by ORA-01653, ORA-01654, don’t rush to follow “Action” to add a datafile, because it might not need to add.