0 Replies Latest reply: Feb 21, 2013 4:06 AM by 992462 RSS

    Materialized view from prebuilt table doesn't work with spatial types?

    992462
      Hello, I'm trying to build a materialized view of a table using the prebuilt option and a pre-built table.

      Oracle gives me an ORA-32304 error, saying it can't do this with user-defined types. The original table has no user-defined types, but does use an sdo_geometry column. Is this what it's complaining about?

      Now I can sort of understand this, but here's my real problem: the materialized view I'm creating is comprised of a subset of the columns from the original table, but not the geometry column. Is Oracle right in refusing my prebuilt request? Does anyone know of a way around this (besides creating the MV from scratch without prebuilt).

      I've successfully created an MV on another table, which doesn't have a spatial column, using the prebuilt option and a subset of columns.

      (I'm using Oracle 11.2.0.2.0 on both master and slave databases)