Re: Oracle Partition Movement
From: Harel Safra <harel.safra_at_gmail.com>
Date: Wed, 3 Nov 2010 13:50:01 +0200
Message-ID: <AANLkTi=AWNqWVB+Qkdqt-+q+qcLp4HW=8nFMz4UXH0sr_at_mail.gmail.com>
You need to exchange the oldest partition with a temp table of the same structure and then exchange that table into the archive table.
Date: Wed, 3 Nov 2010 13:50:01 +0200
Message-ID: <AANLkTi=AWNqWVB+Qkdqt-+q+qcLp4HW=8nFMz4UXH0sr_at_mail.gmail.com>
You need to exchange the oldest partition with a temp table of the same structure and then exchange that table into the archive table.
Harel Safra
Sent from my phone
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 03 2010 - 06:50:01 CDT