Moving Oracle spatial from one database to another

From: George Leontiadis <gleon_at_dblab.ece.ntua.gr>
Date: Tue, 25 Jun 2002 07:52:15 +0300
Message-ID: <afa76o$1ekg$1_at_ulysses.noc.ntua.gr>

I have a 8.1.7 database with spatial option. Our GIS application people have uploaded quite bit of GIS data into Oracle spatial.

Now for a couple of reasons, I want to create/rebuild a new 8i database with spatial option too (no any actual spatial data in it yet) and want to move the spatial data from existing database to this new database using export/import. One problem is Oracle does NOT allow MDSYS user (who owns the metadata tables) to be exported.

Does any one know any workaround or have good/bad experience for doing similar thing? To moving the required metadata, can I simply populate the MDSYS.SDO_GEOM_METADATA_TABLE in the new database with the data in the same table in the existing database?

Thanks for any suggestion/comment. Received on Tue Jun 25 2002 - 06:52:15 CEST

This message: [ Message body ]
Next message: Gennadiy Shestakov: "Re: Full join on Oracle?"
Previous message: Joe: "Oracle 9i Tunning"
Next in thread: Thomas Gaines: "Re: Moving Oracle spatial from one database to another"
Reply: Thomas Gaines: "Re: Moving Oracle spatial from one database to another"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message