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.
DBMS_WM.DisableVersioning( table_name IN VARCHAR2 [, force IN BOOLEAN DEFAULT FALSE]);
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:
LIVE
workspace.
LIVE
workspace.
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.
EXECUTE DBMS_WM.DisableVersioning ('employee');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|