InfoSphere Optim

 View Only
  • 1.  Optim handling Oracle SDO_GEOMETRY data types

    Posted Mon September 20, 2021 01:44 PM
    Hello Team,

    Optim 11.3 looks like not recognizing Oracle tables having SDO_GEOMETRY data types. Any alternative thoughts on how to handle this ? 

    Thank You !

    ------------------------------
    Sam
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Optim handling Oracle SDO_GEOMETRY data types

    IBM Champion
    Posted Mon September 20, 2021 02:01 PM
    Hello Sam,

    Convert SDO_GEOMETRY and move the data into a Varchar data type, archive it and while restoring that data back, convert it into a SDO_GEOMETRY.

    You can also achieve it using a view as well by creating a view with a conversion of the SDO_GEOMETRY column in the view script

    Thanks and regards,
    Vishwas Balakrishna
    Estuate, Inc. Princeton, NJ





  • 3.  RE: Optim handling Oracle SDO_GEOMETRY data types

    Posted Mon September 20, 2021 03:01 PM
    Thanks Vishwa. 

    Can Optim help us with the conversion ? or it need to converted before Optim can recognize the table ? 

    Thank You !

    ------------------------------
    Sam
    ------------------------------