Hello fellows.

I'm creating a new oracle database table.
My table name is tblTest.
But it returns an error code ORA-00903: Invalid Table Name.
I dont know why this happen. I think the table name is right.
But what is the problem actually.

http://img820.imageshack.us/img820/3946/nonametgm.jpg

Thank you.

Recommended Answers

All 5 Replies

can you post the exact syntax that you are using for reference of our experts.

my solution is to put the table name in uppercase form

what exactly is the script that is throwing the above error message ?

actually i created the table using SQL Developer.
it didnt accept table name in lowercase form.

In oracle object names are not case sensitive (if not used inside quotes).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.