This content has been marked as final. Show 4 replies
SDO_NET is a Spatial option, not included in Locator. As far as I know, XE only supports Locator, not Spatial. Besides, XE doesn't have a JVM, so any Locator/Spatial components that are java based are not supported. SDO_NET is java based.
My oracle xe release number: 10.2.0.1.0
So oracle xe doesnt support SDO_NET - update or somethins else isnt possible?
Can I work just with the JAVA API or I need SDO_NET ?
Orcl 10. can support SDO_Net.But you must to grant unlimited for user which you create.
You go to SQL Plus,Login which username SYSTEM and pass when you create database.
You grant for user by command :
GRANT CREATE SESSION TO new_user;
GRANT UNLIMITED TABLESPACE TO new_user;
Now you can use SDO_NET
Edited by: 867016 on Jun 20, 2011 5:29 AM
Edited by: 867016 on Jun 20, 2011 5:38 AM
You are answering a 4 year old forum posting. And the advice you've given makes no sense. The original poster stated they are using Oracle XE - which certainly does not support SDO_NET. You can grant all the tablespace privileges you want to a user on XE, but you still won't be any closer to using SDO_NET. Spatial Networks are a feature of Oracle Spatial, which isn't available on XE. End of story.