RE: partitioned table maintenance

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith
Sent: Wednesday, May 28, 2008 11:27 AM
To: oracle-l@xxxxxxxxxxxxx
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>  

Other related posts: