Technical Blog

To drop a foreign key constraint from a version enable table . EXECUTE DBMS_WM.BeginDDL('PARENT_TABLE'); EXECUTE DBMS_WM.BeginDDL...

dbms_wm.gotodate begin dbms_wm.gotoworkspace('B_focus_1'); end; insert into test values (6,'Wayanad','YS',...

To Refresh workspace begin dbms_wm.gotoworkspace('B_focus_9'); dbms_wm.refreshworkspace('B_focus_9'); end; But if th...

The merge operation does not currently work with versioned tables. The optimizer translates the merge into insert/update statements on the ...

Workspace Manager PL/SQL APIs The PL/SQL APIs in the DBMS_WM package can be executed * Workspace operations: create,refresh,merge,rollb...

With Oracle's Workspace Manager it's possible to have several versions of data. That is, data can be changed, thus making a new vers...