spool all_cltr.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

break on "OWNER" on "TBL - NAME";

/* ****************************************************** */
/*                                                        */
/* substitute the table_name variable with the new        */
/* name in CAPITAL LETTERS                                */
/*  - will show all the clusters for a given database     */
/*                                                        */
/*         @c:\oracle\sql\all_cltr.sql                    */ 
/*                                                        */
/* ****************************************************** */

select 	substr(owner,1,10)                      "OWNER",
        substr(cluster_name,1,10)               "CLUSTER",
        initial_extent				"INIT EXT",
	next_extent				"NEXT EXT",
	cluster_type				"TYPE",
	cache					"CACHED"
from 	all_clusters 
order by 1 asc, 2 asc;

set echo off;
spool off;
set long 80;
commit;









