REM INDICE DE CHAINAGE DES TABLES
REM -----------------------------

SET FLUSH OFF
SET TERM OFF
SET LINESIZE 76
SET PAGES 100 
REM
set pages 100
set linesize 76
column tablespace    heading Tablespace format a20
column table_name    heading Table format a20
column chain_cnt         heading 'Chainage'
start title80 "ETAT SUR L INDICE DE CHAINAGE DES TABLES"
define output = './REPORTS/indicateur5_B.lis'
spool &output
SELECT 
        TABLESPACE_NAME tablespace, 
        table_name , 
        chain_cnt 
FROM SYS.DBA_TABLES
where chain_cnt > 0
ORDER BY chain_cnt desc, TABLESPACE_NAME, TABLE_NAME;
spool off
clear columns
SET FLUSH ON
SET TERM ON
exit