Symptom
The SQL submitted is < select table_name table_name, comments,
table_type from all_tab_comments where owner = '<schema name>'
UNION
select synonym_name table_name, NULL, 'SYNONYM' from all_synonyms a,
all_objects b where a.table_name = b.object_name and a.table_owner =
b.owner and b.object_type IN ('TABLE', 'VIEW', 'MATERIALIZED VIEW') and
a.owner = 'MIFREPDATA' and a.table_owner = '<schema name>' and DB_LINK IS
NULL order by able_name asc>.
Read more...
Environment
SAP Information Steward 14.2.
Oracle 9i.
Product
SAP Information Steward 4.2
Keywords
KBA , EIM-IS-DEP , Information Steward - Deployment Install Upgrade , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.