Let me start out by saying that we know we did things incorrectly, and that "doing it over again the right way" isn't the advice we're looking for in this discussion.
Here's the situation:
- Existing database instance (A) is Oracle 10g on AIX.
- New database instance (B) is Oracle 11g on Solaris.
- We exported our schema from A and imported it into B.
Unfortunately, about 12 tables in the schema were versioned using Workspace Manager in the 10g instance, but no data from WMSYS was exported.
So we have a situation where we have MyTable_LT tables containing rows, but the MyTable views are reporting 0 rows. User_WM_Versioned_Tables reports 0 rows.
It would be perfectly OK with us if we could "unversion" the tables in the new instance, and start again.
Is there a way to determine which rows in the _LT tables are belonging to the LIVE workspace?
Alternatively, is there a way to export/import the metadata from WMSYS in instance A into instance B?
Thanks in advance for your advice.