Return
-
Title
"ORA-00903: Invalid Table Name" Error When Quick Browse (F3) Table Named for Reserved Word -
Description
When using the Quick Browse (F3) feature in the DB Navigator for a table that is named after a reserved word, an "ORA-00903: Invalid Table Name" error will result.
The error is caused by quotes not included and not enclosing the table name. For example, create the USER table as follows:
Create table "USER" (rid number(20));
If the Quick Browse is used on this table, SQL Navigator does not enclose the table in quotes as shown causing the error:
SELECT a.rid
FROM user a
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.