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

/* ****************************************************** */
/*                                                        */
/* Name:    alter_table.sql                               */
/* Purpose: script to spool a listing of all alter table  */
/*          to set the pctioncrease to zero               */
/* Creator: R.Kupcunas                                    */
/* Date:    07-Mar-99                                     */
/*                                                        */
/* ****************************************************** */

set termout on;
set echo on;
set feedback on;

col dummy     	noprint format a1;
col dummy2    	noprint format a1;
col table_name      noprint format a1;
col command   	format a70;

/* ********************************* */
/* 1. Generate drop table commands   */
/* 2. Generate create table commands */
/* ********************************* */

select ' alter table '||owner||'.'||table_name||' storage (pctincrease 0); ' 
from dba_tables where pct_increase >0 and owner not in ('SYS', 'SYSTEM');
               
set termout off;
set echo off;
set feedback off;
  
spool alter_table.rslt
/
spool off;

set echo on;
set feedback on;

@alter_table.rslt
set heading on;
set pagesize 100;
set termout on;











