I was testing the new 23ai free VM shared by Oracle, and i observed very helpful feature of 23ai which shares us the url of the error to read more about it for knowledge. Here is how it works :
So here the table t does not exists, and we get Help page to see about the error and its details and action page
SQL> select * from t;
select * from t
*
ERROR at line 1:
ORA-00942: table or view "SYS"."T" does not exist
Help: https://docs.oracle.com/error-help/db/ora-00942/
SQL> show errordetails
errordetails ON
SQL> set errordetails off
SQL> select * from t;
select * from t
*
ERROR at line 1:
ORA-00942: table or view "SYS"."T" does not exist
SQL> select * from t;
select * from t
*
ERROR at line 1:
ORA-00942: table or view "SYS"."T" does not exist
# Further the verbose page shows more details like Cause: as well.
SQL> set errordetails verbose
SQL> select * from t;
select * from t
*
ERROR at line 1:
ORA-00942: table or view "SYS"."T" does not exist
Help: https://docs.oracle.com/error-help/db/ora-00942/
Cause: The specified table or view did not exist, or a synonym
pointed to a table or view that did not exist.
To find existing user tables and views, query the
ALL_TABLES and ALL_VIEWS data dictionary views. Certain
privileges may be required to access the table. If an
application returned this message, then the table that the
application tried to access did not exist in the database, or
the application did not have access to it.
Action: Check each of the following:
- The spelling of the table or view name is correct.
- The referenced table or view name does exist.
- The synonym points to an existing table or view.
If the table or view does exist, ensure that the correct access
privileges are granted to the database user requiring access
to the table. Otherwise, create the table.
Also, if you are attempting to access a table or view in another
schema, make sure that the correct schema is referenced and that
access to the object is granted.
Params: 1) object_name: The table or view name specified as
SCHEMA.OBJECT_NAME, if one is provided.
Otherwise, it is blank.
No comments:
Post a Comment