DO_TM_TASK
Runs a Tuple Mover operation on the specified table or projection and commits any current transaction.
Tip: Running this function does not require you to stop the tuple mover.
Syntax
DO_TM_TASK('task'[, 'schema.]{table | projection}]')
Parameters
task |
Specifies one of the following tuple mover operations:
|
schema
|
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
table | projection |
Applies task to the specified table or projection. If you specify a projection and it is not found, If no table or projection is specified, the task is applied to all tables and projections in the database. |
Privileges
- Any INSERT/UPDATE/DELETE privilege on table
- USAGE privileges on schema
Examples
The following example performs a moveout of all projections for the t1
table:
=> SELECT DO_TM_TASK('moveout', 't1');
The following example performs a moveout for the t1_proj
projection :
=> SELECT DO_TM_TASK('moveout', 't1_proj');