Re: Can't access a table I just created
- From: jherrick@xxxxxxx
- To: orasnita@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 7 Jul 2010 18:30:15 +0000
It's the double-quotes
If you create "tb" then you have to
Select * from "tb" or
Drop table "tb"
If you had not used the quotes and did a
Create table tb ....
The select * from tb would work the same way as select * from TB
In general....just don't use double-quotes in your object names.
This happens a lot when you auto-convert from Access or ms-sql too
HTH
Sent wirelessly from my BlackBerry device on the Bell network.
Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell.
-----Original Message-----
From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Wed, 7 Jul 2010 21:19:06
To: <oracle-l@xxxxxxxxxxxxx>
Reply-To: orasnita@xxxxxxxxx
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
��i��0���zX���+�� n��{�+i�^
Other related posts:
