Re: Replication of Oracle9i spatial tables as materialized views

From: Thomas Gaines <thomas.gaines_at_noaa.gov>
Date: 14 Apr 2004 09:27:03 -0700
Message-ID: <fb7f8a4a.0404140827.284d9885@posting.google.com>

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 Received on Wed Apr 14 2004 - 11:27:03 CDT