RE: partitioned table maintenance

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 28 May 2008 11:37:18 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A20301409B@EXCHANGE.corp.perceptron.com>

Split your TABLE_MAX partition.
See Oracle docs for "Alter table... split partition...", i.e.:  

ALTER TABLE sales SPLIT PARTITION SALES_Q4_2000

   AT (TO_DATE('15-NOV-2000','DD-MON-YYYY'))    INTO (PARTITION SALES_Q4_2000, PARTITION SALES_Q4_2000b);

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Wednesday, May 28, 2008 11:27 AM
To: oracle-l_at_freelists.org
Subject: partitioned table maintenance

I have inherited a partitioned table with a MAX VALUE partition. All values more than April 1st are going into that partition.
What is the SOP for adding partitions for May, June, and so on and dealing with the MAX VALUE partition?  

Table                          Partition                 Partition
Name                           Name                       Position

NUM_ROWS AVG_ROW_LEN TO_CHAR(LAST_ANALYZ Tablespace

------------------------------ ------------------------- ---------
---------- ----------- ------------------- --------------------
T_TABLE_CALL                    TABLE_200712                      1
0           0 04/24/2008 00:09:27 TABLE_1207_M016
T_TABLE_CALL                    TABLE_200801                      2
0           0 04/24/2008 00:09:28 TABLE_0108_M016
T_TABLE_CALL                    TABLE_200802                      3
0           0 04/24/2008 00:09:28 TABLE_0208_M016
T_TABLE_CALL                    TABLE_200803                      4
0           0 04/24/2008 00:09:28 TABLE_0308_M016
T_TABLE_CALL                    TABLE_MAX                         5
74710         119 05/23/2008 22:00:47 TABLE_MAX_M016
 

Thanks.  

---

E-mail for the greater good. Join the i'm Initiative from Microsoft. <http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ GreaterGood>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 28 2008 - 10:37:18 CDT