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?
+9- 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
- 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
+9- Contributor
david_r wrote:
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.