注册

oracle中package多个视图通过与dba_part_indexes关联过滤本地索引,迁移到达梦后无法识别视图

初心 2024/06/05 425 2 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:x86
【问题描述】*:
源oracle中主要是通过dba_part_indexes这个视图来过滤本地索引,但是达梦这边本地索引和全局索引怎么过滤的?

这是源oracle中package的sql语句:
SELECT c.table_owner,
c.table_name,
c.index_name,
c.column_name,
d.COLUMN_ID,
c.column_position
FROM dba_ind_partitions a,
dba_part_indexes b,
dba_ind_columns c,
dba_tab_columns d
WHERE a.index_owner = b.owner
AND a.index_name = b.index_name
AND b.owner = c.index_owner
AND b.index_name = c.index_name
AND b.table_name = c.table_name
AND a.partition_name = '外部参数'
AND b.table_name = '外部参数'
AND c.table_owner = '外部参数'
AND c.table_owner = d.OWNER
AND c.table_name = d.TABLE_NAME
AND c.column_name = d.COLUMN_NAME
AND b.locality = 'LOCAL'

回答 0
暂无回答
扫一扫
联系客服