RE: Exchange Partition
- From: "Darrell Landrum" <darrell@xxxxxxxxxxx>
- To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 May 2007 22:46:44 -0500
A couple of ideas.
Is T_LDGR_FACT partitioned already? If so, just use merge each of your
2003 partitions into one and exchange that resulting partition with
T_LDGR_FACT_2003 non partitioned table. T_LDGR_FACT would still have 2003
partition but it would now be empty and could be dropped.
or
If T_LDGR_FACT is not partitioned, create an empty copy of it
T_LDGR_FACT_COPY, partitioned as one big partition covering the entire range
of T_LDGR_FACT. Then exchange partition between T_LDGR_FACT and the empty
copy and split the partitions of the resulting table down to the year, then
exchange the 2003 partition with T_LDGR_FACT_2003. Clean up by merging
partitions in T_LDGR_FACT _COPY and exchanging that back to T_LDGR_FACT or
by dropping the original, now empty T_LDGR_FACT and renaming the
partitioned copy of it to T_LDGR_FACT.
I hope this makes sense (and I hope I understand your question) as I'm
slightly handicapped right now by all the details of the Lost season finally
running through my head (Wow!).
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kline.Michael
Sent: Wednesday, May 23, 2007 9:06 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Exchange Partition
I knew about the normal "exchange partition" stuff, but I thought that one
could also "swap partitions" which evidently no.
I've got a 5 year table, say T_LDGR_FACT. I want to make a T_LDGR_FACT_2003
and move all the 2003 partitions to it.
It appears I'll be using insert into x select * from y(partition 200301),
etc. I can break it down into partitions to keep it manageable.
Just was so sure there was a "cheater" way to "move" them. This is 9.2.0.6
on HP_UX.
Michael Kline How
<mailto:Milo.Dalton@xxxxxxxxxxxx;Dan.Divinski@xxxxxxxxxxxx;Vivek.Gangal@SunT
rust.com;Marissa.Porrello@xxxxxxxxxxxx?subject=Michael%20Kline's%20Performan
ce> am I doing?
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505
1030 Wilmer Avenue
Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446
BlackBerry: 804.517.7443
Cell: 804.744.1545
<mailto:michael.kline@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx
Seeing beyond Money(sm)
LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited. If you have received this email
in error please contact the sender and delete the material from any
computer.
SunTrust and Seeing beyond money are federally registered service marks of
SunTrust Banks, Inc.
[ST:XCL]
Other related posts:
