Dbms_wm.export With Export_modified_data_only also Exports Unmodified Rows
(Doc ID 2478027.1)
Last updated on APRIL 17, 2023
Applies to:
Workspace Manager - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
DBMS_WM.EXPORT_MODIFIED_DATA_ONLY also exports also unmodified rows
Using 1 workspace and 1 table as an example, if there are only 11 records of this table that have been updated, i.e. the _DIFF contains 11 records having I/U/D in wm_code column for the workspace:
COUNT(*) |WM_DIFFVER |WM_CODE
---------|----------------------------------- |-------
884 |AP002000000979002000000979, LATEST |NE
11 |AP002000000979002000000979, LATEST |I
11 |LIVE, LATEST |NE
895 |DiffBase |NE
849 |LIVE, LATEST |I
2206 |LIVE, LATEST |U
2171 |AP002000000979002000000979, LATEST |NC
2171 |DiffBase |NC
While the number of records for the same workspace in the staging table are more than 14000, 11 with WM$FLAG = 6 (the 11 records inserted) and 14545 WM$FLAG = 4 :
COUNT(*) |WM$FLAG
-------------|--------
11 |6
14545 |4
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |