| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Not able to view table
In oracle what ever the case we use while creating object name, the data dict willbe updated in upper case.
eg: emp/Emp/EMP are all same for oracle.
(if table is created without double quotes. eg: create table emp (col1 ,
col2 ..)
But in any case if we want to create any object with specific case we have to put them in double quotes.
Next time when you query the object you have to use the same convention.
eg: "emp" / "Emp" / "EMP" are different one from the other.
create table "emp"
(col1
col2 ....)
if you select
select * from emp; you cant see anything.
you have to select
selecdt * from "emp";
HTH
Srinivas
-----Original Message-----
Sent: Friday, November 30, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Mark,
I am a really confused with your last statement.
"Have you tried either of the following:
select * from "tblBundleCon";
select * from 'tblBundleCon';
If you really did create them in lower and upper case, this could be
your
problem. Enclosing the table names in double quotes usually solves
this.."
Would you or someone else elaborate on this, pleeaassee? Are we still talking Oracle here????
-----Original Message-----
Sent: Friday, November 30, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L
Jyoti,
Did you create the tables as SYSTEM? One thing I will say is that *YOU
SHOULD NOT DO THIS*. When creating objects as SYSTEM, these objects will
be
stored in the SYSTEM tablespace - which is not a good idea. As system,
create another tablespace (if one does not already exist), create a new
user, with a default tablespace of the new tablespace, and use this user
(with the appropriate system/object privileges) to create your
tables/indexes/objects.
On to another point about your mail - the password for SYSTEM is
actually
the default. How about changing that for security reasons? This may just
be
a test box, but there's nothing like good safe practice.
Back to the original question:
Who were you logged on as when you created the tables? Where did you create them? (tablespace).
Have you tried either of the following:
select * from "tblBundleCon";
select * from 'tblBundleCon';
If you really did create them in lower and upper case, this could be
your
problem. Enclosing the table names in double quotes usually solves
this..
HTH Mark
-----Original Message-----
Sent: 30 November 2001 06:50
To: Multiple recipients of list ORACLE-L
Hi all,
I have created with the following details:
Global DB name: manu.ifpjyo
SID: manu Username: SYSTEM Password: manager Tables: tblBundleCon, tblTextCon, tblFinalImage
I am able to connect to the database:
SQL> connect system_at_manu
password: *******
Connected.
But I am unable to view the tables that I have created: SQL>select * from tblBundleCon;
*
I get the above error. Where am I going wrong,
Thanx a lot in advance.
Jyoti.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark_at_cool-tools.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Nov 30 2001 - 22:43:21 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: lhoska_at_calibresys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |