[postgis-users] Hw to Oracle dmp file to postgis /postgresql

[Paul Ramsey]

Bruce,

No, I am referring to the full edition of Oracle, that you can  
download, as long as you use it for development purposes only.   
<http://www.oracle.com/database/index.html> Note the "Free Download"  
button to the right. <http://www.oracle.com/technology/software/ 
htdocs/devlic.html?http://www.oracle.com/technology/software/products/ 
database/oracle10g/htdocs/10201ppclinuxsoft.html>

I am not sure of the contents of your dump.  If it's pretty generic  
spatial, you could use a tool like FME to pull it out and stuff it  
into PostGIS.  If it's more custom, you might find that writing a few  
lines of Java code to pull things out and dump them onto disk works  
better.

Paul

On 6-Jan-06, at 11:20 AM, Clay, Bruce wrote:

> Paul:
>   Thanks for your reply.
>
> When you say free, are you referring to Oracle Express?  If I read the
> web page right, it is limited to 4 Gig database.  The database I was
> given is approx 150 gig split into 32 gig chunks.
>
> Does this mean I am stuck with having to load it back into Oracle
> somewhere?
> I don't know Oracle or so this is likely a dumb question. If I can do
> that, how do I extract the maps to put into PostGis?
>
> Bruce
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of  
> Paul
> Ramsey
> Sent: Friday, January 06, 2006 12:24 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Hw to Oracle dmp file to postgis
> /postgresql
>
> Bruce,
>
> No, you are going to have to put it back into Oracle and then extract
> the information in a more portable form.  Fortunately you can
> download Oracle for free for development purposes, so it is "merely"
> a matter of effort, not dollars.
>
> P
>
> On Jan 6, 2006, at 7:11 AM, Clay, Bruce wrote:
>
>> I have seen this question come up before on other forums but I can  
>> not
>> find the answer.
>>
>> I have received some Oracle DMP files containing several map
>> raster.  Is
>> there any way to get PostGis / Postreqsl to import them?
>>
>> I do not have any ASCII / SQL info with them.
>>
>> Thanks for your help.
>>
>> Bruce
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users