Exchange Partition
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 May 2007 22:06:28 -0400
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 am I doing?
<mailto:Milo.Dalton@xxxxxxxxxxxx;Dan.Divinski@xxxxxxxxxxxx;Vivek.Gangal@
SunTrust.com;Marissa.Porrello@xxxxxxxxxxxx?subject=Michael%20Kline's%20P
erformance>
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
michael.kline@xxxxxxxxxxxx <mailto: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:
