RE: Can't access a table I just created

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

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: