issues when creating snapshots of tables with SDO_GEOMETRY column type
This below bug was posted earlier about not being able to drop a snapshot successfully. It is related to this bug, in that, we realized that it was due to SDO_GEOMETRY.
https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=205118&aggregatorResults=T205118&sourceCommunityId=209&sourcePortletId=370&doPagination=true&pagedAggregatorPageNo=1&returnUrl=https://communities.oracle.com/portal/server.pt?open=space&name=CommunityPage&id=3&psname=Opener&psid=2&cached=true&in_hi_userid=283067&control=SetCommunity&PageID=0&CommunityID=209&&Portlet=My Discussions&PrevPage=Communities-Discussions#205118
We are having some problems with some materialized view. When we tried to create a snapshot (or Materialized View) of a table with SDO_GEOMETRY column type from a different server, it runs.
https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=205118&aggregatorResults=T205118&sourceCommunityId=209&sourcePortletId=370&doPagination=true&pagedAggregatorPageNo=1&returnUrl=https://communities.oracle.com/portal/server.pt?open=space&name=CommunityPage&id=3&psname=Opener&psid=2&cached=true&in_hi_userid=283067&control=SetCommunity&PageID=0&CommunityID=209&&Portlet=My Discussions&PrevPage=Communities-Discussions#205118
We are having some problems with some materialized view. When we tried to create a snapshot (or Materialized View) of a table with SDO_GEOMETRY column type from a different server, it runs.
0