Home » Server Options » Spatial » Replication with spatial data.
Replication with spatial data. [message #75318] Mon, 10 February 2003 21:19
Jeffrey
Messages: 30
Registered: January 2003
Member
Hi to all the gurus of oracle replication out there. Being new to Oracle and currently i am assigned to do a replication of the production database which handles spatial data. There is a few question i would like to ask and some problems to sort out.

Here is my scenario:

1. I am using Mapinfo to upload all the spatial datas into Oracle (9.0.1).
2. As far as i know, after uploading the spatial data, a new schema will be created called Mapinfo with the table Mapinfo_catalog. This table stores the name of the table and its schema as well as its bounds and projections.

Here are my questions:

1. After a table with spatial data has been uploaded, a spatial index will be created (eg. LOT_SX). However the spatial index cannot be replicated with the following error message

ORA-02055:distributed update operation failed; rollback required
ORA-06550:line 1, column 109:
PLS-00306:wrong number of arguments in calls to 'ODCIINDEXGETMETADATA'
ORA-06550:line1,column 102:
PL/SQL:Statement ignored
ORA-06512:at"SYS.DBMS_EXPORT_EXTENSION",line 241
ORA-06512:at line 1
ORA-06512:at"SYS.DBMS_METADATA_INT",line 4369

2. If the table(XYZ) has been replicated, i manually create an index an spatial index for the table (no replication is done on the index), will there be any problem when there is updates in the tables. Do i need to recreate the index again on the replicated tables?

3. I have replicated the tables and the schema in which the spatial data are involved and the mentioned Mapinfo schema with its table. What other schemas, tables, views, etc i need to replicate as well.

Any replies, helps and info are welcomed.

Thank you in advance.
Previous Topic: Possible bug in Oracle9.2 SDO_UNION function
Next Topic: Re: connecting c++ with any database
Goto Forum:
  


Current Time: Thu Mar 28 12:48:08 CDT 2024