From lhoska@calibresys.com Fri, 30 Nov 2001 10:43:48 -0800 From: lhoska@calibresys.com Date: Fri, 30 Nov 2001 10:43:48 -0800 Subject: RE: Not able to view table Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: mark@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@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@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@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).