Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exporting Data from one Server to Another server w/ Version Enabled Tables

mike_adnJan 29 2013 — edited Feb 12 2013

Hi,

I'm currently having a problem with regards to Exporting data to another server. This is the Scenario:

Source Server is Production Server with all of its Tables in the Schema are Version-Enabled.

Destination Server is a Test Server.

I exported data from Production Server using EXP command. Then in my Test Server I imported my data using IMP command (I already created tablespace and user for the Schema).

Import is successful in my Test server but when I execute my queries, There are no rows returned.

I checked my _LT tables and it contains my data. but when I query from the View created when version was enabled, no result is returned.

Am I missing something when I exported and imported my Schema? Should I have included the WMSYS schema when I created the .dump file?

Thanks in advance.