Member Avatar for lili.edryana

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.

Edited by lili.edryana because: n/a
  • 2 Contributors
  • 5 Replies
  • 102 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

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

Member Avatar for lili.edryana

my solution is to put the table name in uppercase form

Member Avatar for debasisdas

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

Member Avatar for lili.edryana

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

Member Avatar for debasisdas

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.