Skip to Main Content

Database Software

Missing data on Spatial migration

3429516Jan 26 2018 — edited Jan 29 2018

Hi all,

We are trying to migrate a Oracle Spatial between two enviroments. We are using exp/imp to copy our database schema (GEO_DATA)

However, in the new enviroment after set MapViwer to connect to this schema, we can not see any layer or imformation about maps.

We execute a count(*) on MDSYS.ALL_SDO_STYLES, MDSYS.ALL_SDO_THEMES and MDSYS.ALL_SDO_MAPS, and we find this:

Source enviroment

MDSYS.ALL_SDO_STYLES 1710 Rows

MDSYS.ALL_SDO_THEMES 602 Rows

MDSYS.ALL_SDO_MAPS 4 Rows

Target Enviroment

MDSYS.ALL_SDO_STYLES 78 Rows

MDSYS.ALL_SDO_THEMES 0 Rows

MDSYS.ALL_SDO_MAPS 0 Rows

It looks like the metadata was not loaded into MDSYS.

In your experince about this, are we missing some steps to migrate our Oracle Spatial data?

We would appreciate your help

Regards!

This post has been answered by 3429516 on Jan 29 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2018
Added on Jan 26 2018
3 comments
496 views