Use the following SQL command in an SQL Statement to Execute after Translation to update the SRID value:
In addition there will be no entry in the user_sdo_geom_metadata table for this second geometry column so you can add an entry by issuing the following command once:
INSERT INTO user_sdo_geom_metadata SELECT TABLE_NAME,'<second_geometry_column_name>',DIMINFO,SRID FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = '<Multi_geometry_table_name>';
Updating SRID values in an Oracle geometry column
Article Number: 000001086 - Last Modified: Jul 8, 2011
To handle multiple geometry columns in an Oracle feature class you currently need to insert features for the first geometry column and then update features to update the second geometry column. However this technique does not allow you to insert an SRID value into the second geometry column.