REM ######################################################################
REM * @c:\oracle\sql\tabs_tbl.sql                         
REM *                                                        
REM * Owner: R.Kupcunas                                      
REM * Date:  01-MAY-95                                       
REM *                                                       
REM # display information about tablespace contents (for tables)
REM ######################################################################

set pagesize 80;

break on "OWNER" on "TABLESPACE" on "TABLE";

select substr(owner, 1, 8)                   "OWNER",
	substr(TABLESPACE_NAME,1,15)          "TABLESPACE", 
	table_name                           "TABLE",               
       SUBSTR(to_char(INITIAL_EXTENT),1,10)  "INIT",                 
       SUBSTR(to_char(NEXT_EXTENT),1,8)       "NEXT",                    
       SUBSTR(to_char(MIN_EXTENTS),1,3)       "MIN",                    
       SUBSTR(to_char(MAX_EXTENTS),1,3)       "MAX",                    
       SUBSTR(to_char(PCT_INCREASE),1,3)      "PCT"
   from sys.dba_tables
   order by 1, 2, 3;

commit;
