| 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
Thanx , I was an object-typed table as you said
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]=20
Sent: 17 =E3=C7=ED=E6, 2004 10:33
To: oracle-l_at_freelists.org
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/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
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |