Sunday, June 19, 2011

Enable version & Disable Version

Enable version:

Table name is test

EXEC DBMS_WM.EnableVersioning('TEST');

Disable version:

EXEC DBMS_WM.DisableVersioning('TEST');

We can see versioned tables from
WM$VERSIONED_TABLES in WMSYS user.

We can see version errors in WM$VT_ERRORS_TABLE in WMSYS user.

No comments:

Post a Comment