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@manu
password: *******
Connected.
But I am unable to view the tables that I have created:
SQL>select * from tblBundleCon;
*
ERROR at line 1:
ORA-00942: table or view does not exist
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
