partitioned table maintenance

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 28 May 2008 10:27:18 -0500
Message-ID: <BLU108-W547E04696E1624CFE9028197BC0@phx.gbl>

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

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

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