Thank you very much, for all the members that helped me. Octavian ----- Original Message ----- From: "Aragon, Gabriel (GE, Corporate, consultant)" <gabriel.aragon@xxxxxx> To: <orasnita@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, July 07, 2010 9:25 PM 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