PRODDTA table descriptions query

[Guest]

I want to run a SQL query to extract the table descrptions for tables in the
PRODDTA schema.

The nearest offer I got in-house was:

select siobnm, simd
from obj7333.f9860
where siobnm in (
select rpad(table_name,10,' ') from dba_tables)
order by siobnm;

But from what I can determine this results in tables from PRODCTL schema in
the mix. Anyone any solutions for only PRODDTA.

OneWorld Xe B7333 SP15.2 - Oracle 8.1.7 - W2K
-------------------------
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
--------------------------------------------------------------------
This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.
--------------------------------------------------------------------

 

[Larry_Jones]

Try this Sean,

select dt.table_name, ol.simd
from dba_tables dt, obj7333.f9860 ol
where dt.owner = 'PRODDTA'
and dt.table_name = RTRIM(ol.siobnm)
order by dt.table_name;

You need to use a oracle login that has DBA privileges.
(It may take a while to run also)

 

[vivek_kaushal]

You can replace dba_tables with all_tables... so you do not need Oracle login with DBA rights.

 

[sunnyind]

There is a document on Knowledge garden which details out the all env. system table OTI-01-0069

regards