Good point - I should have mentioned that.. Thanks Kimberly.
-----Original Message-----
Smith
Sent: 30 November 2001 17:47
To: Multiple recipients of list ORACLE-L
Hum, must disagree (sort of). Although I don't recommend creating objects
as system normally the first thing I do when I create a database is change
the default tablespace of all users except sys. OK, it might not be the
first thing I do, but its up there in the beginning somewhere.
You could also use the data dictionary to find your tables. Look in
dba_tables
or dba_objects. But Mark has a good point about the case of your tables.
-----Original Message-----
Sent: Friday, November 30, 2001 4: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: Kimberly Smith
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: 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).
