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
Estuate, Inc. Princeton, NJ
Original Message:
Sent: 9/20/2021 1:44:00 PM
From: Sam
Subject: Optim handling Oracle SDO_GEOMETRY data types
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