Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Not able to view table

RE: Not able to view table

From: <lhoska_at_calibresys.com>
Date: Fri, 30 Nov 2001 10:43:48 -0800
Message-ID: <F001.003D22CD.20011130102531@fatcity.com>

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;

                            *

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: 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-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: 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). Received on Fri Nov 30 2001 - 12:43:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US