Truncate Table Script (trunctbl.ksh)
Module Name |
trunctbl.ksh |
Description |
Truncate Table Script |
Functional Area |
Foundation |
Module Type |
Admin |
Module Technology |
KSH |
Catalog ID |
RMS475 |
Wrapper Script |
rmswrap_shell.ksh |
Design Overview
This program performs truncate operations on a Merchandising table or a specific partition. It accepts an input table name and an optional partition name. If no partition name is passed, then the truncate is applied on the entire table.
This program must be run as either the Merchandising schema owner, or be run by a user that has been granted the following system privileges:
-
drop any table
-
alter any table
Currently, the following action and tables are processed by the batch. For the runtime parameters, refer to the Oracle Retail Merchandising Batch Schedule.
Table 2-9 Actions and Tables Processed by Batch
Table | Partition |
---|---|
NIL_INPUT_WORKING |
N/A |