MapInfo Pro

 View Only

  • 1.  Do I need a MI_PRINX column in an Oracle Spatial table?

    Posted 10-30-2023 21:30

    Hello all,

    I am building a spatial table in Oracle

    I have a Primary Key column "IDENTIFIER"

    I have a geometry column "GEOMETRY"

    I am trying and failing to open this table in MapInfo v2019, by opening a DBMS connection and opening the table as Live (not Linked)

    Do I need one of the columns to be "MI_PRINX"? I know that used to be a requirement, is it still required?



    ------------------------------
    Nick Lawrence
    Senior Spatial Science Officer
    TMR-Policy and Planning
    Brisbane QLD
    ------------------------------


  • 2.  RE: Do I need a MI_PRINX column in an Oracle Spatial table?

    Employee
    Posted 10-31-2023 02:41

    Hi Nick

    MapInfo Pro only supports Oracle Spatial through an Oracle Call Interface (OCI). We do not support it through ODBC, unfortunately.

    The primary key column can have any name in a base table. In a view, we only pick up the primary key column if it is named MI_PRINX.

    You can find more details here: Connecting to an Oracle database in a MapInfo Pro application



    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------

    Original Message