REM *********************************************************
REM * @c:\oracle\sql\chain_up.sql                            *
REM *                                                        *
REM * Owner: R.Kupcunas                                      *
REM * Date:  01-MAY-95                                       *
REM *                                                        *
REM * Table chain analyze script; update the table to remove
REM *     the chaining                                       * 
REM *********************************************************

spool chain_up.rslt

create table temp as 
  select * from &&CHAINED_TABLE;

truncate table &&CHAINED_TABLE;
 
insert into &&CHAINED_TABLE
    select * from temp;
 
drop table temp; 

undefine chained_table;
spool off;

