What do you mean by "complex geometry column" ? Do you mean that you have tables with "simple geometry columns" and some with "complex geometry columns" and the latter are not visible while the former are ?
Did you actually confirm that all your spatial tables are recorded inside Geomedia's own metadata dictionary (GDOSYS) as suggested in the other topic you mention ?
Are all tables also defined in Oracle Spatial's own metadata tables (USER_SDO_GEOM_METADATA) ?
Are the tables in multiple database schemas ? If so did you grant the proper privileges to the database user you use for connecting Geomedia ? In other words, does that user see all the spatial tables you want it to see ? Try connecting as that user and do the following:
select owner,table_name from all_table_names;
will show all the tables (spatial and others) this user can access (= select from)
select owner,table_name from all_sdo_geom_metadata;
will show all the spatial tables this user can access. Are all the tables you want to access in those lists ? If any is missing from the first list, it means that you did not grant the proper privilege (SELECT) on those tables to the user Geomedia connects as. If they are in the first list, but not in the second, it means that those tables do not have any corresponding definition in Oracle Spatial's metadata.
To complete the answer: most GIS tools have restrictions that limit what the database allows. Here are the only database-side requirements:
- A spatial column must be properly defined in USER_SDO_GEOM_METADATA
- A spatial column must have a spatial index
- All geometries in a spatial column must be in the same coordinate system and the same dimensionality (all 2D or all 3D)
Beyond that, no other requirements exist. In particular, the following are all possible:
- A table can contain any number of spatial column (each then has its own metadata definition and spatial index)
- A spatial column can contain any mix of shapes (points, lines, polygons, solids ...)
- Views and synonyms can be freely used
- Tables can exist in any combination of schemas
- Queries operate on any mix of coordinate systems
- Tables can have any kind of referential integrity (primary and foreign keys)
But most GIS tools have the following common restrictions:
- Only one spatial column per table
- Only one kind of shape per spatial column (points OR lines OR polygons)
- Views may work, but require their own metadata definition (not used by Oracle)
- Synonyms rarely work
- Single-column numeric primary key (no composite primary keys)