|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 12 of 52
This procedure deletes all support structures that were created to enable the table to support versioned rows.
Name of the table. The name is not case sensitive.
This procedure is used to reverse the effect of the EnableVersioning Procedure. It deletes the Workspace Manager infrastructure (support structures) for versioning of rows, but does not affect any user data in the
LIVE workspace. The workspace hierarchy and any savepoints still exist, but all rows are the same as in the
LIVE workspace. (If there are multiple versions in the
LIVE workspace of a row in the table for which versioning is disabled, only the most recent version of the row is kept.)
The DisableVersioning operation fails if the
force value is
FALSE and any of the following apply:
Only the owner of a table or a user with the
WM_ADMIN_ROLE role can disable versioning on the table.
Tables that are version-enabled and users that own version-enabled tables cannot be deleted. You must first disable versioning on the relevant table or tables.
An exception is raised if the table is not version-enabled.
The following example disables the
EMPLOYEE table for versioning.