Vantage supports shredding to columns of the following data types.
CHAR | VARCHAR | CLOB |
BYTE | VARBYTE | BLOB |
BYTEINT | SMALLINT | INTEGER |
BIGINT | FLOAT (for data types where applicable, precision is supported) | DECIMAL |
NUMBER | DATE | TIME |
TIME WITH TIME ZONE | TIMESTAMP | TIMESTAMP WITH TIME ZONE |
INTERVAL YEAR | INTERVAL YEAR TO MONTH | INTERVAL MONTH |
INTERVAL DAY | INTERVAL DAY TO HOUR | INTERVAL DAY TO MINUTE |
INTERVAL DAY TO SECOND | INTERVAL HOUR | INTERVAL HOUR TO MINUTE |
INTERVAL HOUR TO SECOND | INTERVAL MINUTE | INTERVAL MINUTE TO SECOND |
INTERVAL SECOND | PERIOD (DATE) | PERIOD (TIME) |
PERIOD (TIME WITH TIME ZONE) | PERIOD (TIMESTAMP) | PERIOD (TIMESTAMP WITH TIME ZONE) |
XML | JSON |