Insert into save_table any row for which a new partitioning level evaluates to a value outside the valid range of 1 through the number of partitions defined for that level. After it inserts the non-valid row, Vantage deletes it from the table.
You can use this option with row-level security-protected tables as long as the tables referenced in the request are all row-level security-protected and they are all be defined with the same row-level security constraints.
- INTO
- Optional keyword.
- save_table
- save_table and the table being altered must be different tables, and save_table must have the same number of columns (with matching data types) as the table being modified.