View Suresh Vaishya's profile
The table to store discoverer is stored in the EUL Schema. For e.g. if the name of EUL is EUL4_US then a schema with that name will be created in oracle database. Run following query to know the name of table
SELECT owner,table_name
FROM all_tables
WHERE owner = 'EUL4_US' AND table_name LIKE '%DOCUMENT%'
The above query in this case will list table_name EUL4_DOCUMENTS
All the discoverer report names are stored in this table, so
SELECT * FROM EUL4_US.EUL4_DOCUMENTSshould display name, owner etc of discoverer reports
4 Comments:
The query made my task so easy.
Thanks
That assumes that one knows the EUL...
Try this:
SELECT OWNER, TABLE_NAME
FROM ALL_TABLES
WHERE OWNER LIKE '%EUL%'
AND TABLE_NAME LIKE '%DOCUMENT%'
Actually, I just found that we also have OWNER = 'DISCOVERER'.
Maybe just look for like %DOCUMENT% and look for reasonable OWNER's
Right on!
Thank you,
I was looking for the list of reports in Disc EUL
..masoud
Post a Comment