17,377
社区成员
发帖
与我相关
我的任务
分享如何对远程数据库上的表创建索引
在MYDB上创建了DBLINK至TRANS_DB,现登陆MYDB，如何将下述语句实现？谢谢
declare ln_index_sfcz number;
begin
select count(*)
into ln_index_sfcz
from dba_indexes
where index_name = 'IDX_TRANS_DJ_NSRXX_SBH'
and owner = 'TRANS_DB';
if ln_index_sfcz=0 then
EXECUTE IMMEDIATE 'CREATE INDEX TRANS_DB.IDX_TRANS_DJ_NSRXX_SBH ON TRANS_DB.DJ_NSRXX(NSRSBH)';
end if;
end;
declare ln_index_sfcz number;
begin
select count(*)
into ln_index_sfcz
from dba_indexes
where index_name = 'IDX_TRANS_DJ_NSRXX_SBH'
and owner = 'TRANS_DB';
if ln_index_sfcz=0 then
EXECUTE IMMEDIATE 'CREATE INDEX TRANS_DB.IDX_TRANS_DJ_NSRXX_SBH ON TRANS_DB.DJ_NSRXX(NSRSBH)';
end if;
end;
...全文
