The name of the partition in which the new subpartition resides. The name (optionally schema-qualified) of the partitioned table in which the subpartition resides. ADD SUBPARTITION command you must be the table owner, or have superuser (or administrative) privileges.
If the table is indexed, the index is created on the new subpartition. If you don't specify a tablespace, the subpartition is created in the default tablespace. Include the TABLESPACE clause to specify the tablespace in which the subpartition resides. You cannot add a new subpartition that precedes existing subpartitions in a range subpartitioned table range subpartitions must be specified in ascending order. You can split an existing subpartition with the ALTER TABLE… SPLIT SUBPARTITION statement, effectively adding a subpartition to a table. You cannot use the ALTER TABLE… ADD SUBPARTITION statement to add a subpartition to a table with a MAXVALUE rule. You can use the ALTER TABLE… ADD SUBPARTITION statement to add a subpartition to a table with a DEFAULT rule as long as there are no conflicting values between existing rows in the table and the values of the subpartition to be added. The new subpartition rules must reference the same column specified in the subpartitioning rules that define the existing subpartition(s). New subpartitions must be of the same type ( LIST, RANGE or HASH) as existing subpartitions. There is no upper limit to the number of defined subpartitions. The ALTER TABLE… ADD SUBPARTITION command adds a subpartition to an existing partition the partition must already be subpartitioned. Toggle Wrap Copy ALTER TABLE MODIFY PARTITION
0 kommentar(er)
