Home » Server Options » Spatial » Spatial Cartridge in oracle (10.2.0.2)
Spatial Cartridge in oracle [message #345290] Tue, 02 September 2008 16:44 Go to next message
varunvir
Messages: 324
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,
Re: Spatial Cartridge in oracle [message #345311 is a reply to message #345290] Tue, 02 September 2008 23:31 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Spatial Cartridge in oracle [message #345824 is a reply to message #345290] Thu, 04 September 2008 23:20 Go to previous messageGo to next message
varunvir
Messages: 324
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,
Re: Spatial Cartridge in oracle [message #352182 is a reply to message #345824] Mon, 06 October 2008 09:10 Go to previous message
anil_mk
Messages: 110
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
Previous Topic: Spatial index on a table with partitions
Next Topic: Data for Spatial
Goto Forum:
  


Current Time: Mon Jul 28 20:16:27 CDT 2014

Total time taken to generate the page: 0.08744 seconds