Partition exchange

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Tue, 18 Apr 2006 16:14:31 -0400
Message-ID: <367369f10604181314r85eefet45bd23a2d1815f9d@mail.gmail.com>

Hi List,
I have 2 step exchange partition process ( step 1 ) from source partitioned table to non-partitioned temp; step 2) from temp to target partitioned table ). I am trying to find a way to revert changes to initial state if proces fails in step 2.
I know I can reexecute exchange partition from step 1 but that would imply rebuilding indexes first.
Creating dummy partition is also not an option for the same reason ( there is max partition in this table; which implies partition splitting, which will
again make indexes unusable ).
I could create dummy table as exact copy of the source table on the fly, and dry run with it. This looks too much trouble though.

Any ideas ?

--

Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 18 2006 - 15:14:31 CDT