DROP_PARTITION
Drops the specified partition. If the WOS contains table data, DROP_PARTITION
forces a moveout before it executes the drop operation.
Syntax
DROP_PARTITION ( '[schema.]table‑name', partition‑value [, ignore‑moveout‑errors] [, reorganize‑data ] )
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
table‑name |
The target table. The table cannot be used as a dimension table in a pre-join projection and cannot have out-of-date (unrefreshed) projections. |
partition‑value |
The key of the partition to drop. |
ignore‑moveout‑errors |
Optional Boolean argument:
Note: If you set this parameter to |
reorganize‑data |
Optional Boolean argument:
|
Privileges
One of the following:
- DBADMIN
- Table owner
- USAGE privileges on the table schema and TRUNCATE privileges on the table
Examples
See Dropping Partitions in the Administrator's Guide.