ORA-00903: invalid table name

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 )