Try to avoid using "" because also your columns names will have same problem, you do this normally to name objects using reserved words, like create table "PROCEDURE" or something like that which is strongly suggested to be avoided. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Aragon, Gabriel (GE, Corporate, consultant) Sent: Miércoles, 07 de Julio de 2010 01:25 p.m. To: orasnita@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Can't access a table I just created Well I guess is a matter of case, try : drop table "tb"; -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Octavian Rasnita Sent: Miércoles, 07 de Julio de 2010 01:19 p.m. To: oracle-l@xxxxxxxxxxxxx Subject: Can't access a table I just created Hi, Our sysadmin recently installed Oracle and he created the user "teddy" for me. I have created a table, but I can't select from it and I can't drop it either. Here is what I tried after logging with the username "teddy" in sqlplus: SQL> CREATE TABLE "tb" ( "id" number NOT NULL, "symbol" varchar2(20) NOT NULL, PRIMARY KEY ("id") ); 3 4 5 Table created. SQL> SQL> drop table tb; drop table tb * ERROR at line 1: ORA-00942: table or view does not exist SQL> drop table TB; drop table TB * ERROR at line 1: ORA-00942: table or view does not exist SQL> drop table teddy.tb; drop table teddy.tb * ERROR at line 1: ORA-00942: table or view does not exist SQL> select count(*) from tb; select count(*) from tb * ERROR at line 1: ORA-00942: table or view does not exist SQL> select count(*) from teddy.tb; select count(*) from teddy.tb * ERROR at line 1: ORA-00942: table or view does not exist SQL> After so many tries, I think something's wrong. I have created 2 more other tables, but I can't access them either. Our sysadmin said that he can access that table if he connects to the database with my username using a GUI program, SQL Developer if I remember well, and that he was also able to add data to that table. Do you have any idea what could be wrong? (Oracle newbie here) Thanks. Octavian -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l