ADD Clause

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

(1)
ADD Clause

1  ADD
1 ? ? 1 PARTITION part REMAINDER IN?  PARTITION part IN  dbspace
1 ?  PARTITION part %ADD Expression  IN dbspace? 1
2.1 BEFORE
2.1 AFTER
1 fragment
1 2 INTERVAL  ? STORE IN ( + , new_dbspace )
ADD Expression

1 2
2.1 VALUES  <  range_expr
2.1 3 VALUES
IS NULL
1  expression
1 4 VALUES 
2.1 + , const_expr
2.1 3? IS NULL
Notes:
  • 1 List or expression fragmentation only
  • 2 Range interval fragmentation only
  • 3 Use path no more than once
  • 4 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.