| 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: Table not exists
Select object_name,object_type
>From user_objects
Where upper(object_name) =3D'WWSEC_ENABLER_CONFIG_INFO$'
Object_name object_type =09
No rows selected
-----Original Message-----
From: Justin Cave (DDBC) [mailto:jcave_at_ddbcinc.com]=20
Sent: 17 =E3=C7=ED=E6, 2004 10:31
To: oracle-l_at_freelists.org
Subject: RE: Table not exists
Can you post the appropriate section of the output from the SELECT =
statement
that queries the user_objects view? Perhaps the table was created in a
case-sensitive manner...=3D20
Justin Cave
Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Feras Al-Qadi
Sent: Monday, May 17, 2004 1:05 AM
To: oracle-l_at_freelists.org
Subject: Table not exists
I have table in oracle 8.1.7 , it is a portla table named
WWSEC_ENABLER_CONFIG_INFO$,
I can see the table in user_objects with type "TABLE" , but when I =
issue the
command Select * from user_tables Where table_name =3D3D
'WWSEC_ENABLER_CONFIG_INFO$';
Return no rows
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon May 17 2004 - 02:27:26 CDT
 |
 |