| 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
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_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 - 12:00:50 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: Kimberly Smith INET: ksmith2_at_myfirstlink.net 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).
 |
 |