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
----------------------
---------------------
WWSEC_ENABLER_CONFIG_INFO$              TABLE

Select table_name
From user_tables
Where upper(table_name) =3D'WWSEC_ENABLER_CONFIG_INFO$'

No rows selected


-----Original Message-----
From: Justin Cave (DDBC) [mailto:jcave@xxxxxxxxxxx]=20
Sent: 17 =E3=C7=ED=E6, 2004 10:31
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Feras Al-Qadi
Sent: Monday, May 17, 2004 1:05 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: