set echo off
REM RUDIMENTARY PARTITIONING OBE
REM
REM v0.1
REM
REM mwiel       10/18/06        - initial creation
REM hbaer       02/07/07        - first adjustments and extensions
REM
REM
REM
REM

REM 
REM REF Partitioning
REM 

set echo off

set pagesize 2000
set long 10000
set linesize 200
set feedback on
column partition_name format a25
column high_value format a85
set echo on
set feedback on

-- cleanup 

alter table orders drop partition p2007_01;
alter table orders drop partition p2007_02;

drop tablespace x;
drop tablespace y;