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

Thanks Vishwa. 

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

Thank You !

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

Original Message:
Sent: Mon September 20, 2021 02:00 PM
From: Vishwas Balakrishna
Subject: Optim handling Oracle SDO_GEOMETRY data types

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

C: +1 818 309 0972

E: vishwas.balakrishna@estuate.com

Estuate, Inc. Princeton, NJ