partitioned table maintenance

From: Joe Smith <joe_dba@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 28 May 2008 10:27:18 -0500

I have inherited a partitioned table with a MAX VALUE partition.  All values 
more than April 1st are going intothat partition.
What is the SOP for adding partitions for May, June, and so on and dealing with 
the MAX VALUE partition?
 
Table                          Partition                 PartitionName          
                 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_M016T_TABLE_CALL  
                  TABLE_200801                      2          0           0 
04/24/2008 00:09:28 TABLE_0108_M016T_TABLE_CALL                    TABLE_200802 
                     3          0           0 04/24/2008 00:09:28 
TABLE_0208_M016T_TABLE_CALL                    TABLE_200803                     
 4          0           0 04/24/2008 00:09:28 TABLE_0308_M016T_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

Follow-Ups:

RE: partitioned table maintenance
From: Mercadante, Thomas F (LABOR)

RE: partitioned table maintenance
From: Igor Neyman

partitioned table maintenance

Other related posts: