查詢依賴關係的objects 是否有被DDL過
SELECT a.object_type,
a.object_name,
b.owner,
b.object_type,
b.object_name,
b.object_id,
b.status,
b.last_ddl_time
FROM sys.DBA_OBJECTS a,
sys.DBA_OBJECTS b,
( SELECT object_id, referenced_object_id
FROM public_dependency
START WITH object_id =
(SELECT object_id
FROM sys.DBA_OBJECTS
WHERE wner = 'DFMS'
AND object_name = 'SP_WIP_TRANSFER'
AND object_type = 'PROCEDURE')
CONNECT BY PRIOR referenced_object_id = object_id) c
WHERE a.object_id = c.object_id
AND b.object_id = c.referenced_object_id
AND a.owner NOT IN ('SYS', 'SYSTEM')
AND b.owner NOT IN ('SYS', 'SYSTEM')
AND a.object_name <> 'DUAL'
AND b.object_name <> 'DUAL'
ORDER BY 8 DESC;
a.object_name,
b.owner,
b.object_type,
b.object_name,
b.object_id,
b.status,
b.last_ddl_time
FROM sys.DBA_OBJECTS a,
sys.DBA_OBJECTS b,
( SELECT object_id, referenced_object_id
FROM public_dependency
START WITH object_id =
(SELECT object_id
FROM sys.DBA_OBJECTS
WHERE wner = 'DFMS'
AND object_name = 'SP_WIP_TRANSFER'
AND object_type = 'PROCEDURE')
CONNECT BY PRIOR referenced_object_id = object_id) c
WHERE a.object_id = c.object_id
AND b.object_id = c.referenced_object_id
AND a.owner NOT IN ('SYS', 'SYSTEM')
AND b.owner NOT IN ('SYS', 'SYSTEM')
AND a.object_name <> 'DUAL'
AND b.object_name <> 'DUAL'
ORDER BY 8 DESC;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-627387/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 查詢鎖之間的依賴關係Oracle
- Oracle 查詢鎖之間依賴關係的最源頭SIDOracle
- Maven 依賴關係Maven
- build task依賴關係UI
- 關聯關係與依賴關係的區別
- 透過遞迴查詢應用依賴遞迴
- 透過shell分析表依賴的層級關係
- 通過shell分析表依賴的層級關係
- MySQL 查詢鎖之間依賴關係的資訊和最源頭鎖的thread_id號及關係MySqlthread
- MySQL查詢鎖之間依賴關係的資訊和最源頭鎖的thread_id號及關係MySqlthread
- ORACLE包和過程依賴關係測試(轉)Oracle
- OSGI中的service依賴關係管理
- 多值依賴的有關概念
- Spring框架模組依賴關係Spring框架
- mysql主外來鍵依賴關係MySql
- depmod解決模組依賴關係
- 【物件導向依賴關係概念總結】物件導向程式設計的五種依賴關係物件程式設計
- Android專案的依賴關係解析Android
- 分析資料庫的依賴關係(轉)資料庫
- 查詢物件是否被鎖物件
- Struts2所有依賴關係(struts-2.5.14.1)
- 【python】【安裝包依賴關係】Python
- 解決rpm包依賴關係
- 依賴注入是否值得?依賴注入
- Elasticsearch依賴與Spring對應關係ElasticsearchSpring
- 使用 .NET Core 實現依賴關係注入
- maven中scope依賴範圍與classpath的關係Maven
- .NET Core新增專案之間的依賴關係
- 使用yum 安裝依賴關係較多的包
- SQL如何實現查詢節點依賴SQL
- Gradle的Task(2)任務間的依賴關係Gradle
- gcc 標頭檔案依賴關係 分析工具GC
- 關於DBA_OBJECTS的LAST_DDL_TIMEObjectAST
- Maven中如何管理多模組專案的依賴關係Maven
- 如何管理前端專案中的複雜依賴關係前端
- Makefile 自動生成標頭檔案的依賴關係
- 物件導向程式設計程式碼詳解(依賴關係,關聯關係,組合關係)物件程式設計
- spring cloud alibaba 元件版本關係 以及 畢業版本依賴關係SpringCloud元件