Re: Oracle Spatial tables

From: Marty Grinstead <marty_grinstead_at_hotmail.com>
Date: Tue, 25 Sep 2001 19:58:53 -0000
Message-ID: <FU8s7.8684$Ko.4072491@newsrump.sjc.telocity.net>

Hi Zifeng

If you already have spatial installed on the second DB (mdsys user exists), all you need to do is export the spatial tables from your existing DB, and import them into the new database. You will probably have to manually insert the data into the USER_SDO_GEOM_METADATA view in the new database, but that shouldn't be a big deal.

Hope this helps,
Marty

zifeng li <zifeng.li_at_compudigm.co.nz> wrote in message news:3BB010E8.F4CE302_at_compudigm.co.nz...
> Hi,
>
> I uploaded some spatial data by MapInfo into a Oracle database.
>
> Now, I want to transfer the spatial tables from one to another
> Oracle database without using MapInfo again. Please, who
> know the easy way to do the job.
>
> Thanks
>
> Zifeng
>
>
Received on Tue Sep 25 2001 - 14:58:53 CDT