Views arent in all_tables, they are
in all_views.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of AK
Sent: Friday, August 08, 2003 1:19
PM
To: Multiple recipients of list
ORACLE-L
Subject: tables
:
Subject:RE: tables and views
Join TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only columns that
belong to tables. You should also set _disable_suboptimal_app_design to TRUE
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED
Subject: RE: tables and views
Join
TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only
columns that
belong to tables. You should also set _disable_suboptimal_app_design to
TRUE
--Mladen GogalaOracle DBA
-Original Message-From: [EMAIL
Title: RE: tables and views
You need to look into all_objects also. It tells you if it is a table or view.
SELECT DISTINCT c.owner, c.table_name, o.object_type
FROM all_tab_columns c, all_objects o
WHERE c.table_name = o.object_name
AND c.owner = o.owner
AND o.object_type = 'TABLE
Title: Message
All
columns from view and tables appear in ALL_TAB_COLUMNS; to differentiate the
source of the columns, you need to join to ALL_TABLES for the table columns, or
to ALL_VIEWS for view columns, or if you need to know what type of object the
column came from (instead of
Title: Message
Join
TAB$ and COL$ directly (on OBJ#) and your problem is gone. You'll get only
columns that
belong
to tables. You should also set _disable_suboptimal_app_design to
TRUE
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL