Geospatial data can have a maximum size of approximately 16MB, allowing for representations of approximately one million points.
It is a Vantage limit that you cannot create a table with more than six LOB columns. By default, ST_Geometry columns are LOBs, so they are subject to this limit. However, you can create ST_Geometry columns that are not LOBs by specifying a maxlength of less than or equal to 64,000 bytes with no INLINE LENGTH specification in the column type definition. That restricts the size of the ST_Geometry data to a size that can be stored within a row, rather than in a LOB subtable. For more information on defining ST_Geometry columns, see ST_GeometryType Method.
Additionally, Teradata load utilities that cannot directly load LOB types similarly cannot load ST_Geometry types unless you specify that ST_Geometry types use a non-default transform group. The transform group used for ST_Geometry data can be specified in the CREATE/MODIFY USER and CREATE/MODIFY PROFILE SQL statements. For more information on specifying transform groups, see Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144.