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 [email protected]#$ (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 )

 

 790 views last month,  6 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply