OraFAQ Forum: Spatial » Spatial Cartridge in oracle

Home » Server Options » Spatial » Spatial Cartridge in oracle (10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spatial Cartridge in oracle [message #345290]

Tue, 02 September 2008 16:44

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi,
Does spatial cartridge comes installed on oracle 10.2.0.2 or is there any other software to install oracle with spatial cartridge.

Regards,
Varun Punj,

Report message to a moderator

Re: Spatial Cartridge in oracle [message #345311 is a reply to message #345290]

Tue, 02 September 2008 23:31

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to first explicitly check the spatial option at installation time (or later to add the option) and then to execute the appropriate scripts to include it in your database.

Regards
Michel

Report message to a moderator

Re: Spatial Cartridge in oracle [message #345824 is a reply to message #345290]

Thu, 04 September 2008 23:20

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Michel,
I have two database running on production server.The client wants to have third database with spatial cartridge enabled on it.Is there any downtime required for that.I never saw any option of spatial cartridge while creating database.

Regards,
Varun Punj,

Report message to a moderator

Re: Spatial Cartridge in oracle [message #352182 is a reply to message #345824]

Mon, 06 October 2008 09:10

anil_mk
Messages: 146
Registered: August 2006
Location: Bangalore, India

Senior Member

Hi Varun,

As i installed the Oracle 10.2.0.1.0 which has Oracle Spatial default. Even in your Production Database Server the Oracle Spatial has got installed when you installed the Server.
So if you want to check whether the Spatial is installed or not, you can by running the below statement in your server.

select comp_name,status from DBA_REGISTRY where comp_name ='Spatial';

Regards,
Anil MK

Report message to a moderator

Previous Topic:	Spatial index on a table with partitions
Next Topic:	Data for Spatial

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 09:09:42 CDT 2025