I'm trying to find the oracle error's description in SQL*PLUS. Similar command in DB2 as
XXXX is the error number.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You can use oerr utility.
[oracle@ora12c Desktop]$ oerr ora 01950 01950, 00000, "no privileges on tablespace '%s'" Cause: User does not have privileges to allocate an extent in the specified tablespace. Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace.
Note: This utility is not available on Windows.
You can prepend an exclamation mark
! in SQL*Plus to any shell command which will allow you to execute the command without leaving SQL*Plus:
Connected to: Oracle Database 11g Release 220.127.116.11.0 - 64bit Production SQL> !oerr ora 01950 01950, 00000, "no privileges on tablespace '%s'" // *Cause: User does not have privileges to allocate an extent in the // specified tablespace. // *Action: Grant the user the appropriate system privileges or grant the user // space resource on the tablespace. SQL>
Well, for Windows, i can only remember calling the the SQLERRM function.
Something like this:
DBMS_OUTPUT.PUT_LINE('SQLERRM(-6511): ' || TO_CHAR(SQLERRM(-6511)));