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:
UPDATE <table> a SET a.<geometry_column>.sdo_srid = 90112;
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>';
Suggested Similar Articles
A description of some of the functionality in the Oracle Spatial Object Reader/Writer.
For FME to make a spatial query against Oracle spatial tables or spatial views there needs to be metadata entries in the MDSYS.SDO_GEOM_METADATA table.
It is possible to use Oracle spatial tables from within ArcCatalog, within ArcMap, and via the Data Interoperability extension if the tables have been set up with the correct spatial index and an indexed column
"What's Great" is a summary list of all the new and updated functionality in a particular version of FME. This is the second part of the list for FME Desktop and Server for 2013.
Discusses the issues around inserting fractional seconds into Oracle.