Farklı Databaselerdeki Indexleri Oluşturma
declare CURSOR c1 IS SELECT p.index_owner,p.table_owner,p.table_name,p.index_name, wm_concat(p.column_name) kolonlar FROM DBA_IND_COLUMNS p WHERE table_name =:TABLE_NAME AND NOT EXISTS (SELECT 1 FROM dba_ind_columns@diger_db r WHERE p.index_name=r.index_name AND p.index_owner=r.index_owner ) GROUP BY p.index_owner,p.table_owner,p.table_name,p.index_name; BEGIN FOR r1 IN c1 loop dbms_output.put_line('CREATE INDEX '||r1.index_owner||'.'||r1.index_name||' ON '||r1.table_owner||'.'||r1.table_name||' ('||r1.kolonlar||');' ); end loop; end;