Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

we plan to have two oracle databases, one with oracle spatial installed, the other one just has the locator option.

Is it possible to create an oracle database link between the two databases in order to share the vector data stored in the 'spatial-instance'. Or could we get problems with columns of type SDO_GEORASTER?

Of course we do not plan to perform any 'spatial operations' on the locator-instance , we just want to share the vector data.

Regards, D3

P.S.: we have to use two different databases since we cannot migrate the standard database to 'spatial', the license cost for spatial would be significant and the migration would be too complex.

share|improve this question
Why do you want two separate databases? – Mat Nov 24 '12 at 9:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.