Mapviewer and its tables

Question

Dear All,

I have mapviewer setup in one instance by someone. and they're not using navteq spatial data but their legacy data.

Problem is: they used same schema to load the spatial data along with other warehouse table objects(not BI Apps)

We have no clue / document which dmp or how did they populate the test with spatial data and it's related objects.

My question is: is there any way to find out the underlying table objects being used by current mapviewer setup?

Also, Can we migrate existing setup like "Tile Layers", "Manage Map Data" from one instance to another instead re-creating. (datasource in mapviewer can be created manually)

Please let us know your comments, helpful to me.

Appreciate your great support & time here.

Thanks

Probs · Answer

You're almost there..

Yes you need to migrate the base tables along with the spatial metadata in user_sdo*

Shams Abbasi · Answer

you do not see base maps and tile layers in both the environments?

user13140310 · Answer

Hi,

If i understand it well..

1.  I need to configure mapbuilder to source database(from where i need to migrate) and make note of those layers, themes, maps

2.  Copy tables - Meaning, using the oracle doc Id, i need to migrate .dmp to target schema (to where i want to migrate)

3.  Execute SQLs in target schema..

I did above with following results..

1.  When i configure mapbuilder i do not see any base maps, TILE LAYERS..etc (I see few user_sdo_themes has got base_table column where i see list of 47 tables. Do i need to migrate these along with data to target schema?)

2.   Copy table, - Hope you want me to copy user_sdo related tables.. did that

3.  I see same number of rows and data in user_sdo related tables when compare to source schema

Thanks