|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem: Find all table names in db and then find the list of SP used by this table [message #326644 is a reply to message #326625] |
Thu, 12 June 2008 02:43   |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If I remember correctly, what SQL Server refers to as Databases as Schemas in Oracle.
You can get a list of the tables in those schemas with this query:SELECT owner,table_name
FROM all_tables
WHERE owner in ('DB1','DB2','DB3');
To get a list of procedures using these tables, a query like this will suffice:select name,type,owner,referenced_name,referenced_owner
from all_dependencies
where referenced_owner in ('DB1','DB2','DB3')
and type in ('PACKAGE','PACKAGE BODY','PROCEDURE','FUNCTION'); |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
]