Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 13 of 52
This procedure creates the necessary structures to enable the table to support multiple versions of rows.
DBMS_WM.EnableVersioning( table_name IN VARCHAR2 [, hist IN VARCHAR2 DEFAULT 'NONE']);
The table that is being version-enabled must have a primary key defined.
Only the owner of a table can enable 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.
Tables owned by SYS
cannot be version-enabled.
An exception is raised if the table is already version-enabled.
If the table is version-enabled with the VIEW_WO_OVERWRITE
hist option specified, this option can later be disabled and re-enabled by calling the SetWoOverwriteOFF Procedure and SetWoOverwriteON Procedure. However, the VIEW_WO_OVERWRITE
hist option can be overridden when a workspace is compressed by specifying the compress_view_wo_overwrite
parameter as TRUE
with the CompressWorkspace Procedure or CompressWorkspaceTree Procedure.
The history option affects the behavior of the GotoDate Procedure. See the Usage Notes for that procedure.
Current notes and restrictions include:
The following example enables versioning on the EMPLOYEE
table.
EXECUTE DBMS_WM.EnableVersioning('employee');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|