I'm trying to use the DatabaseJoiner transformer to link to an Oracle Spatial view (not table), but the SDO column is not appearing, nor is the geometry showing up in the resulting joined features. Can this transformer be used for this purpose?
Solved
Use DatabaseJoiner to link Oracle Spatial View?
+10- Contributor
Best answer by david_r
It is possible that you'll have to manually add the spatial view metadata in the "user_sdo_geom_metadata" table, e.g.:
insert into user_sdo_geom_metadata
using select 'RT43495_VIEW', column_name, diminfo, srid
from all_sdo_geom_metadata
where owner = 'DEV' and table_name = 'RT43495';See also this article for more information: https://knowledge.safe.com/articles/782/adding-metadata-entries-for-oracle-spatial-tables.html
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
It is possible that you'll have to manually add the spatial view metadata in the "user_sdo_geom_metadata" table, e.g.:
insert into user_sdo_geom_metadata
using select 'RT43495_VIEW', column_name, diminfo, srid
from all_sdo_geom_metadata
where owner = 'DEV' and table_name = 'RT43495';See also this article for more information: https://knowledge.safe.com/articles/782/adding-metadata-entries-for-oracle-spatial-tables.html
+10- Contributor
It is possible that you'll have to manually add the spatial view metadata in the "user_sdo_geom_metadata" table, e.g.:
insert into user_sdo_geom_metadata
using select 'RT43495_VIEW', column_name, diminfo, srid
from all_sdo_geom_metadata
where owner = 'DEV' and table_name = 'RT43495';See also this article for more information: https://knowledge.safe.com/articles/782/adding-metadata-entries-for-oracle-spatial-tables.html