Database DataWarehousing (MOSC)

MOSC Banner

issues when creating snapshots of tables with SDO_GEOMETRY column type

edited Jun 6, 2011 9:55PM in Database DataWarehousing (MOSC) 1 commentAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center