ADD Clause

Use the ADD clause to add another fragment to a list of fragments of an existing table or index.


ADD Clause

|--ADD---------------------------------------------------------->

>--+-+-----------------------------------------+--+---------------------+--dbspace--------+--|
   | '-+-----------------------+--REMAINDER IN-'  '-PARTITION--part--IN-'                 |   
   |   |  (1)                  |                                                          |   
   |   '-------PARTITION--part-'                                                          |   
   +-+-----------------+--| ADD Expression |--IN--dbspace--+----------------------------+-+   
   | '-PARTITION--part-'                                   |  (1)                       | |   
   |                                                       '-------+-BEFORE-+--fragment-' |   
   |                                                               '-AFTER--'             |   
   |                                   .-,-----------.                                    |   
   |  (2)                              V             |                                    |   
   '-------INTERVAL--+-------+--IN--(----new_dbspace-+--)---------------------------------'   
                     '-STORE-'                                                                

ADD Expression

      (2)                                     
|--+-------+-VALUES <  range_expr-+-------+---------------------|
   |       |  (3)                 |       |   
   |       '-------VALUES IS NULL-'       |   
   +-expression---------------------------+   
   |                 .-,----------.       |   
   |  (4)            V            |       |   
   '-------VALUES -+---const_expr-+-----+-'   
                   |  (3)               |     
                   '-------+----+--NULL-'     
                           '-IS-'

Notes:

List or expression fragmentation only
Range interval fragmentation only
Use path no more than once
List fragmentation only

Element	Description	Restrictions	Syntax
`dbspace`	Name of a dbspace to store the new fragment	Must exist If the table is in a tenant database, the `dbspace` must be a dedicated dbspace in the tenant database properties list. If the table is not in a tenant database, the `dbspace` cannot be the name of a dbspace that is dedicated to a tenant database.	Identifier
`expression`	Expression that defines the new fragment that is to be added	Must return a Boolean value (`t` or `f`)	Condition; Expression
`fragment`	Name of an existing fragment	Must exist	Identifier
`new_dbspace`	Name of a dbspace being added to store new interval fragments	Must exist If the table is in a tenant database, the `new_dbspace` must be a dedicated dbspace in the tenant database properties list. If the table is not in a tenant database, the `new_dbspace` cannot be the name of a dbspace that is dedicated to a tenant database.	Identifier
`part`	Name that you declare here for the new fragment. The default is the name of the dbspace.	Required if another fragment in the fragment list is stored in the same dbspace. Must be unique among names of fragments of the index.	Identifier

The expression can contain column names only from the current table, and data values only from a single row. No subqueries or aggregates are allowed. In addition, the built-in CURRENT, DATE, DBINFO, SYSDATE, and TODAY expressions are not valid in this context.