SQL & PL/SQL

Hello out there,

i'd like to compare the indexes of two databases via database link. Recently I discovered a couple of function based indexes so I have to extend my script to also use USER_IND_EXPRESSIONS but the interesting column COLUMN_EXPRESSION is of datatype LONG, so that I cannot apply substr or any other function to it.

So is there any other data dictionary view I could use?

My script does something like this:

select i.index_name, i.table_name, i.uniqueness, substr(c.column_name, 1, 30) spalte
from user_indexes@dblink i , user_ind_columns@dblink c
where i.index_name = c.index_name
minus
select i.index_name, i.table_name, i.uniqueness, substr(c.column_name, 1, 30) spalte
from user_indexes i, user_ind_columns c
where i.index_name = c.index_name;

This is spooled to a file using SQL*Plus. I'm Using Oracle 11.2.0.2 on Windows if that matters.

Regards,

dhalek