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
Discusses the issues around inserting fractional seconds into Oracle.
FME is able to write multiple geometry types to an existing PostGIS table defined already with multiple geometry types. We cannot write a new geometry type column to an existing table. Example table in PostGIS: ID (int) = 1 Name (char) = test Geom (Geometry) = point Geom2 (Geometry) = line