WebThe CREATE OR REPLACE TYPE statement throws an error if the type being replaced has table or type dependencies. This applies to objects, varrays, and nested table types. This also applies to type dependencies involving either inheritance or type composition (embedding one type into another). WebSep 15, 2010 · I am having a table (REPT_ALL) with dependent objects on it ( child tables, indexes, constraints, views, synonyms, sequences , packages,procedures,functions,triggers). I want the query to find out all the above dependencies for the above table (REP_ALL).
oracle - PL/SQL - how to identify sequences used by tables?
WebNov 11, 2013 · SELECT DISTINCT owner,name,referenced_owner,referenced_name,referenced_type, LEVEL Le1 FROM dba_dependencies where owner =user START WITH NAME = 'object name' CONNECT BY NOCYCLE PRIOR referenced_name = NAME --AND PRIOR REFERENCED_OWNER = … WebFeb 21, 2007 · how to find the dependencies of table Hi Tom !!!!How to find the dependencies of table, if one procedure received the values of tables dynamically.For … lithonia ollwd
sql query to find dependencies for a table - Oracle Forums
WebApr 7, 2024 · SELECT TABLE_OWNER, TABLE_NAME, REFERENCED_OWNER AS SEQUENCE_OWNER, REFERENCED_NAME AS SEQUENCE_NAME FROM ALL_DEPENDENCIES d JOIN ALL_TRIGGERS t ON TRIGGER_NAME = d.NAME AND t.OWNER = d.OWNER WHERE REFERENCED_TYPE = 'SEQUENCE'; Note, a sequence might be used … WebMar 10, 2011 · DBA_DEPENDENCIES - in fact anything about dependencies you see anywhere in our documentation - is about dependencies between schema objects such as tables, views, plsql, etc. We know nothing about your data and how to process it and what your concept of a dependency is. WebJun 10, 2024 · If you have privilege on dba_dependencies select owner as view_schema, name as view_name, referenced_owner as referenced_schema, referenced_name as referenced_table from sys.dba_dependencies where type = 'MATERIALIZED VIEW' and referenced_type = 'TABLE' order by view_schema, view_name; Columns view_schema - … in 1960 the first veteran received