Re: Can't access a table I just created

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

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


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


Other related posts: