Re: How to use Oracle Spatial with synonyn

Its a bit tricky to determine what your problem might be without any versions or even the error message being generated. I guess one thing you might want check is that SCHEMA2 can see the index in the ALL_SDO_INDEX_INFO and ALL_SDO_INDEX_METADATA views but if you need any more help the db version,index creation statement and failing statement would be useful.

Cheers,

Ian

|---------+----------------------------->


|         |           ecandrietta_at_gmail.|

|         |           com               |

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           08/11/2008 00:47  |

|         |           Please respond to |

|         |           ecandrietta       |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       oracledba.williams_at_gmail.com                                                                 |
  |       cc:       hrishys_at_yahoo.co.uk, oracle-l_at_freelists.org                                                  |
  |       Subject:  How to use Oracle Spatial with synonyn                                                       |
  >--------------------------------------------------------------------------------------------------------------|

Hi friends,

  I would like to know if everyone has or had experience using Oracle Spatial with synonyn.
  For example, I have a schema (SCHEMA1) where I have created my tables.   I have another schema (SCHEMA2) that has a synonyn pointed to tables at SCHEMA1. Note, the table has SDO_GEOMETRY and spatial index.   When I run a package connected as SCHEMA2 to insert data, the Oracle generate error because it does not recognize the spatial index created in the SCHEMA1.
 I also applied grant SELECT on spatial indexes to SCHEMA2.

 Any idea to solve this issue.

Best Regards
Eriovaldo

This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.

For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk

Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications

Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics

The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes. †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Mon Nov 10 2008 - 04:33:38 CST