I got ” ORA-00903: invalid table name ” error in Oracle.
ORA-00903: invalid table name
Details of error are as follows.
ORA-00903: invalid table name. Cause: A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER or DROP CLUSTER statement. Action: Check spelling. A valid table name or cluster name must begin with a letter and may contain only alphanumeric characters and the special characters $, _, and #. The name must be less than or equal to 30 characters and cannot be a reserved word
invalid table name
This ORA-00903 errors are related with the table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER or DROP CLUSTER statement.
To solve this error, Check table_name is spelled correctly or not.
Or Check table name used by the schema name or not (e.g. hr.employees )
Table name Rules in Oracle
Check The table name must begin with a letter and table name can not be longer than 30 characters.
And The table name must be made up of alphanumeric characters or the following special characters: $, _, and #.
The table name can not be a reserved word.
If you don’t obey these rules, you will get the errors as follows.
SQL> create table from (id int); create table from (id int) * ERROR at line 1: ORA-00903: invalid table name SQL> create table .,#$_ (id int); create table !@#$ (id int) * ERROR at line 1: ORA-00903: invalid table name SQL> create table 1453 (id int); create table 1453 (id int) * ERROR at line 1: ORA-00903: invalid table name
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )