RE: Can't access a table I just created
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <orasnita@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Jul 2010 14:30:31 -0400
You need to add the double quotes
Do a select * from "tb", just the way you created the table
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Octavian Rasnita
Sent: Wednesday, July 07, 2010 2:19 PM
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
*
--
//www.freelists.org/webpage/oracle-l
Other related posts:
