RE: Table not exists
- From: Feras Al-Qadi <AlQadif@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 17 May 2004 10:36:15 +0300
Thanx , I was an object-typed table as you said
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]=20
Sent: 17 =E3=C7=ED=E6, 2004 10:33
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Table not exists
Perhaps WWSEC_ENABLER_CONFIG_INFO$ is
an object-type table. Try the same query against views
user_object_tables
or
user_all_tables
The view user_tables reports only the relational tables.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st
----- Original Message -----=20
From: "Feras Al-Qadi" <AlQadif@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, May 17, 2004 8:05 AM
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 =3D
'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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
