ORA-39799: The Column Index Number Is Out Of Range (max: Number) (Doc ID 1582496.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Trying to do an export import using export/import Datapump getting errors:

ORA-39799: The column index number is out of range (max: number)


The SOURCE database has the type sdo_ordinate_array as

CREATE TYPE sdo_ordinate_array AS VARRAY (10000000) of NUMBER;

which is a way to extend the number of vertices

but now we are importing into a database that has the original type which is:

CREATE TYPE sdo_ordinate_array AS VARRAY (1048576) of NUMBER;

Meaning

FROM:
CREATE TYPE sdo_geometry AS OBJECT (
SDO_GTYPE NUMBER,
SDO_SRID NUMBER,
SDO_POINT SDO_POINT_TYPE,
SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,
SDO_ORDINATES SDO_ORDINATE_ARRAY);
with
CREATE TYPE sdo_ordinate_array AS VARRAY (10000000) of NUMBER;

IMPORTING INTO Database with:
CREATE TYPE sdo_geometry AS OBJECT (
SDO_GTYPE NUMBER,
SDO_SRID NUMBER,
SDO_POINT SDO_POINT_TYPE,
SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,
SDO_ORDINATES SDO_ORDINATE_ARRAY);
with
CREATE TYPE sdo_ordinate_array AS VARRAY (1048576) of NUMBER;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms