为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:x86
【问题描述】:
oracle中查询本地分区索引表时候条件中有index_owner字段过滤,达梦中并没有这个字段,如果只根据索引名称进行过滤会不会有问题?(源oracle系统中存在一个用户访问多个模式),请大神指导
oracle中的sql语句1:
SELECT COUNT ()
INTO v_count
FROM dba_ind_partitions
WHERE index_owner = v_tabown
AND index_name = v_index_name
AND status = 'UNUSABLE';
oracle中的sql语句2:
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 = i.partition_name
AND b.table_name = i.table_name
AND c.table_owner = i.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'
表dba_ind_partitions有字段sch_name可以区分,dba_ind_columns有字段index_owner,dba_tab_columns有字段owner可以区分