Script: is the index in the TS it should be?

db: Oracle 8/8i, a SAP-environment

I got some new db's to administrate. Normally the indexes are in the same
tablespace as the tables, except for the last letter ( z.b. a table is in the TS PSAPBTABD and the indexes on this table are in PSAPBTABI). However this is not the case in my new db's. Does anyone have a SQL-script that can check if the indexes on a table are
in the indextablespace the should be?
If have written a sql-sript myself wich runs for hours and with no result. So
thats why this question.

Please make a CC to spoele_at_commit.nl

Thanks,
Eric van der Spoel

Script I use:
rem Run by user SYSTEM or SYS
rem

set pagesize 200

Column index_name        Format A15         
Column tablespace_name   Format A15         
Column table_name        Format A15         

SELECT a.index_name     ,
       a.tablespace_name, 
       a.table_name     , 
       b.tablespace_name

    SUBSTR(b.tablespace_name,1,length(b.tablespace_name)-1)) ORDER BY a.index_name;

spool off

exit Received on Fri Aug 24 2001 - 10:28:43 CEST