All -

Is it even possible to replicate tables that contains one
or more columns of type mdsys.sdo_geometry? I read in chapter 6
of the Oracle9i Advanced Replication guide under "Datatype
Considerations" that Oracle supports the replication of
a "user-defined datatype", and I assume that that category
includes the type mdsys.sdo_geometry. I'll be attempting
this very soon, but as I think ahead, a few issues come up:

1. Is it recommended to replicate the information
in the Oracle spatial metadata tables? The spatial metadata
views user/all/dba_sdo_geom_metadata (and many others) are
based upon permanent tables in the mdsys schema, and I generally
consider these "system"-type schemas to be off-limits as far
as replication is concerned. Perhaps I need to change my
thinking in this area.

2. I know that I'll have to replicate the spatial indexes as well
as the accompanying spatial index tables. Is there anything here
that I need to be aware of?

Thanks for your time. Do you have any other recommendations as I
attempt this replication of my Oracle spatial tables?

Thanks,
Tom

Hi,
I've already tried replication with an sdo_geometry column and there are
no problems.

I've just replicate one table, but not the indexes nor the metadata
tables. In my experince I have a subset of the information on the
updatable materialized view site (so the extents will be different too)
so I decided not to replicate the index. I don't know if this is the
best approach but it worked out. I have just kept it simple.

I suggest you to read the Oracle Spatial Best Practices on

http://otn.oracle.com/products/spati..._practices.pdf


bye,
Pedro


Thomas Gaines wrote:
> All -
>
> Is it even possible to replicate tables that contains one
> or more columns of type mdsys.sdo_geometry? I read in chapter 6
> of the Oracle9i Advanced Replication guide under "Datatype
> Considerations" that Oracle supports the replication of
> a "user-defined datatype", and I assume that that category
> includes the type mdsys.sdo_geometry. I'll be attempting
> this very soon, but as I think ahead, a few issues come up:
>
> 1. Is it recommended to replicate the information
> in the Oracle spatial metadata tables? The spatial metadata
> views user/all/dba_sdo_geom_metadata (and many others) are
> based upon permanent tables in the mdsys schema, and I generally
> consider these "system"-type schemas to be off-limits as far
> as replication is concerned. Perhaps I need to change my
> thinking in this area.
>
> 2. I know that I'll have to replicate the spatial indexes as well
> as the accompanying spatial index tables. Is there anything here
> that I need to be aware of?
>
> Thanks for your time. Do you have any other recommendations as I
> attempt this replication of my Oracle spatial tables?
>
> Thanks,
> Tom

Pedro -

Thanks for your response. I'm quite familiar with the Best Practices
doc that you mentioned, and it makes just a passing reference
to replication of a spatial table.

My desire is to be able to consider a fully functional spatial table
(by this, I mean having the ability to perform a spatial query against
that table, thus requiring the presence of the metadata and spatial
index) on one database and then replicate the table and its required
"accessories" to another database and do the same spatial query over there.

If I am to have many read-only materialized views on the destination
database, then I have to replicate all of the pieces, right? Connecting
to the destination database and creating and maintaining the indexes
and metadata there is not an option for me.

Any thoughts? I am seeing nothing at all in the official Oracle docs
regarding this topic.

Thanks again,
Tom