column object_name format a30
select
a.owner, a.object_name, a.object_type
from
dba_objects a
where
a.owner = '&BASE_OBJECT_SCHEMA'
-- choose the appropriate object types for the "base object"
and a.object_type in
('FUNCTION', 'MATERIALIZED VIEW', 'PACKAGE', 'PROCEDURE',
'SEQUENCE', 'TABLE', 'VIEW')
and not exists
(select null from dba_synonyms b
where
b.owner = '&SYNONYM_SCHEMA'
and a.owner = b.table_owner
and a.object_name = b.table_name
-- include this line if the synonym must have the same name as the
-- "base object"
and b.table_name = b.synonym_name
)
order by a.owner, a.object_type, a.object_name ;
select
a.owner, a.object_name, a.object_type
from
dba_objects a
where
a.owner = '&BASE_OBJECT_SCHEMA'
-- choose the appropriate object types for the "base object"
and a.object_type in
('FUNCTION', 'MATERIALIZED VIEW', 'PACKAGE', 'PROCEDURE',
'SEQUENCE', 'TABLE', 'VIEW')
and not exists
(select null from dba_synonyms b
where
b.owner = '&SYNONYM_SCHEMA'
and a.owner = b.table_owner
and a.object_name = b.table_name
-- include this line if the synonym must have the same name as the
-- "base object"
and b.table_name = b.synonym_name
)
order by a.owner, a.object_type, a.object_name ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/94384/viewspace-600268/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Windows WMIC命令详解 (Windows Management Instrumentation Command-line)
- 为monitor打PSU4 (10.2.0.4.4)的步骤
- 重建控制文件 recreate control file
- 停库前执行alter system checkpoint 很重要!
- 参加oracle 数据中心优化高峰会
- 用RMAN迁移文件到ASM或从ASM迁出
- 常用sql
- 分区操作常用sql
- How to Get a 10046 trace for a Parallel Query [ID 1102801.1]
- Master Note Parallel Execution Wait Events [ID 1097154.1]
