partitioning reorg using EXP/IMP

partitioning reorg using EXP/IMP

1. export the table
--------------------
exp / compress=n direct=y tables=DSSWH.F_PROGRAM_PARTICIPATION log=DSSWH.F_PROGRAM_PARTICIPATION.log file=DSSWH.F_PROGRAM_PARTICIPATION.dmp &

2. Rename just to have a backup if things go south
--------------------------------------------------
SQL> rename F_PROGRAM_PARTICIPATION  to F_PROGRAM_PARTICIPATION_old;


2. drop all constraints and indexes at this point
--------------------------------------------------

3. recreate table with what-ever partitions you need
----------------------------------------------------

4. Reload the data
------------------
imp / ignore=y indexes=n constraints=n fromuser=DSSWH touser=DSSWH log=DSSWH.F_PROGRAM_PARTICIPATION.imp_log file=DSSWH.F_PROGRAM_PARTICIPATION.dmp &

.