Oracle® Database Application Developer's Guide - Workspace Manager 10g Release 1 (10.1) Part Number B10824-01 |
|
|
View PDF |
This appendix lists the Workspace Manager error messages, including the cause and recommended user action for each.
LIVE
workspaces in the workspace hierarchy or explicit savepoints in the LIVE
workspace.LIVE
workspace and there may be no explicit savepoints. A clean install of Workspace Manager is needed on the import platform.LATEST
version of a workspace.LATEST
version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.LATEST
version of a workspace.LATEST
version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.LATEST
version of a workspace.LATEST
version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.WM_ADMIN_ROLE
role can version-disable a table in another schema.WM_ADMIN_ROLE
can version-enable a table in another schema.WM_ADMIN_ROLE
or the owner of the workspace can alter workspace attributes.WM_ADMIN_ROLE
or the owner of the workspace can freeze a workspace.WM_ADMIN_ROLE
role or the owner of the workspace can set the workspace lock mode.WM_ADMIN_ROLE
role or the owner of the workspace or savepoint can alter the savepoint attributes.WM_ADMIN_ROLE
role or the owner of the workspace or savepoint can delete the savepoint.LIVE
workspace. The LIVE
workspace is the root workspace in the workspace hierarchy tree.LIVE
.LIVE
workspace. The LIVE
workspace is the root workspace in the workspace hierarchy tree.LIVE
.LIVE
workspaces.FORCE
option of DisableVersioning.SYS
.SYS
.ACCESS
and MERGE
privileges on the workspace on which it was invoked; or, in a multiparent workspace environment, the user does not have both ACCESS
and MERGE
privileges on the non-root workspaces and ACCESS
privilege on the root workspace of the multiparent workspace graph.ACCESS
privileges on the parent workspace of the workspace it was invoked on.ACCESS
and MERGE
privileges on the workspace on which it was invoked.ACCESS
privileges on the workspace on which it was invoked.ACCESS
privileges on the workspace on which it was invoked.ACCESS
and REMOVE
privileges on the workspace on which it was invoked.WM_ADMIN_ROLE
role.LATEST
version of the workspace.LATEST
version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.LATEST
version of the workspace.LATEST
version in the workspace by using the GotoWorkspace or GotoSavepoint procedures.VIEW_WO_OVERWRITE
or VIEW_W_OVERWRITE
option and the cumulative length of the names of the primary key columns was greater than 600.PUBLIC
. Verify correct spelling of the grantee parameter.grant_option
parameter may only be YES
or NO
.in_date
time less than the create time of the current workspace.in_date
parameter for GotoDate must be greater than or equal to the create time for the current workspace.SELECT
, INSERT
, UPDATE
and DELETE
privileges on the versioned table.SELECT
, INSERT
, UPDATE
and DELETE
privileges on the versioned table being conflict resolved.CREATE
privileges on a workspace to be allowed to create a workspace off of it. Privileges can be granted using the grantWorkspacePriv or the grantSystemPriv procedures. Use the function GetPrivs to see which privileges you have on a workspace.GRANT
option to be able to grant it to others.SELECT
, INSERT
, UPDATE
and DELETE
privileges on all versioned tables that were modified in the input workspace.SELECT
, INSERT
, UPDATE
and DELETE
privileges on all versioned tables that were modified in the input workspace.NONE
, VIEW_W_OVERWRITE
, and VIEW_WO_OVERWRITE
.where_clause
parameter as input.where_clause
parameter contains only valid column names and has proper syntax.ACCESS_WORKSPACE
, MERGE_WORKSPACE
, ROLLBACK_WORKSPACE
, REVOKE_WORKSPACE
, and CREATE_WORKSPACE
.freezewriter
parameter.lock_mode
parameter of procedure LockRows.lock_mode
are E
and S
(default is E
).lock_mode
parameter (fifth parameter) of procedure UnlockRows.lock_mode
are E
, S
, and ES
(default is ES
).all_or_user
parameter (fourth parameter) of procedure UnlockRows.all_or_user
. The valid values for all_or_user
are ALL
and USER
(default is USER
).LIVE
workspace.LIVE
. The LIVE
workspace is the default workspace for any session that is connected and Workspace Manager does not monitor users in the LIVE
workspace. Do not invoke this method on the LIVE
workspace.ACCESS
privilege.ACCESS
privilege.LIVE
workspace in NO_ACCESS
mode. Workspace Manager does not support this mode for the LIVE
workspace.READ_ONLY
, 1WRITER
, 1WRITER_SESSION
, WM_ONLY
) modes to freeze the LIVE
workspace.ACCESS
privilege on the parent workspace of the workspace for which lockRows in invoked.ACCESS
privilege on the workspace for which LockRows in invoked.ACCESS
privilege.ACCESS
privilege can be passed to SetMultiWorkspaces.LIVE
workspaces and then version-disable the table without the FORCE option.SELECT
privilege on the parent table.SELECT
privilege on the parent table. Grant the required privilege before version-enabling.SELECT
or DELETE
privilege on the child table.SELECT
and DELETE
privileges on the child table. Grant SELECT
and DELETE
privileges on the child table to the owner of the table being version-enabled.SELECT
privilege on the child table.SELECT
and DELETE
privileges on the child table. Grant SELECT
and DELETE
privileges on the child table to the owner of the table being version-enabled.ACCESS
and MERGE
privileges on the child workspace on which it was invoked; or, in a multiparent workspace environment, the user does not have both ACCESS
and MERGE
privileges on the non-root workspaces and ACCESS
privilege on the root workspace of the multiparent workspace graph.ACCESS
privilege on the parent workspace.ACCESS
privilege on the parent workspace before invoking RefreshTable or RefreshWorkspace. Privileges can be granted using the GrantWorkspacePriv or the GrantSystemPriv procedures. Use the GetPrivs function to see which privileges the current user has on a workspace.LIVE
workspace.LIVE
workspace. The user needs to be in the LIVE
workspace before invoking CreateWorkspace for creating a continually refreshed workspace.BASE
.BASE
. Choose another workspace name.LIVE
.LIVE
. Choose another workspace name.freezemode
parameter.NO_ACCESS
, READ_ONLY
, 1WRITER
, 1WRITER_SESSION
, WM_ONLY
). Ensure that FreezeWorkspace is invoked with the correct parameters.freezewriter
parameter.freezewriter
parameter for the FreezeWorkspace procedure can be non-null only when the freezemode
parameter is 1WRITER
. Ensure that FreezeWorkspace is invoked with the correct parameters.keep
parameter.keep
parameter to the ResolveConflicts procedure is one of (CHILD
,PARENT
,BASE
). This parameter is not case sensitive. See the Resolving Conflicts section of the Workspace Manager documentation for details on the process of conflict resolution.LIVE
workspace. Workspace Manager only supports the RollbackToSP operation for the LIVE
workspace.LIVE
workspace.LIVE
workspace. Do not invoke MergeWorkspace on the LIVE
workspace.LIVE
workspace.LIVE
workspace, use the RollbackToSP operation. To remove descendants to the LIVE
workspace, use the RemoveWorkspace operation on the child workspaces.LIVE
workspace.LIVE
workspace. Do not invoke RefreshWorkspace on the LIVE
workspace.lockmode
parameter.E
(exclusive) or S
(shared). For a discussion of the differences and similarities between these two modes, see the Workspace Manager documentation.WM_ADMIN_ROLE
using the UnfreezeWorkspace procedure.where_clause
parameter as input.where_clause
parameter contains only valid column names and has proper syntax. The where_clause
parameter for this Workspace Manager operation can contain only columns that are part of the primary key.LATEST
savepoints in the workspace. CompressWorkspace requires that all sessions in the specified workspace be on the LATEST
version of the workspace.LATEST
savepoint using GotoSavepoint. Privileged users can view all the sessions in a workspace using the DBA_WORKSPACE_USERS view.LIVE
workspace.LIVE
workspaces.ACCESS
privileges on the workspace.ACCESS
privileges on the workspace. Invoke the UnlockRows operation only on workspaces that you have ACCESS
privileges for.WM_ADMIN_ROLE
or the user who initiated the BeginResolve operation on the workspace can issue a CommitResolve or RollbackResolve call for that workspace.force
parameter.WM_ADMIN_ROLE
.WM_ADMIN_ROLE
.lockMode
parameter have a non-null value.lockmode
parameter for this operation to succeed.WM_ADMIN_ROLE
role or the owner of the workspace can unfreeze a frozen workspace.where_clause
parameter of LockRows to specify those rows that have not already been versioned.LIVE
workspace.LIVE
workspace.freezewriter
parameter.freezewriter
parameter of the FreezeWorkspace procedure must be null whenever the session_duration
parameter is TRUE. The freezewriter
is implicitly assumed to be the currently connected session. Ensure that FreezeWorkspace is invoked with the correct parameters.session_duration
parameter.session_duration
parameter of the FreezeWorkspace must be TRUE when attempting to freeze a workspace in 1WRITER_SESSION mode. Ensure that FreezeWorkspace is invoked with the correct parameters.FREEZE_WORKSPACE
privilege on the workspace, or FREEZE_ANY_WORKSPACE
or WM_ADMIN_ROLE
system privilege, to the user trying the operation.LIVE
workspaces.FORCE
option of DisableVersioning.SQL> EXECUTE SYS.OWM_MIG_PKG.AllFixSentinelVersion;
ignore_last_error => TRUE
' with DisableVersioning.)auto_commit
value of TRUE
is invalid if the current session has an open database transaction on that workspace.auto_commit
value of FALSE
.NONCR_WORKSPACE_MODE
is set to PESSIMISTIC_LOCKING
.NONCR_WORKSPACE_MODE
is set to OPTIMISTIC_LOCKING
. To see the current Workspace Manager system parameter settings, use the WM_INSTALLATION metadata view.WE
mode can further edit the row in the same workspace.VE
mode can further edit the row.NONE
for the workspace
parameter is permitted only with VE
as the value for lock_mode
.lock_mode
value other than VE
.CR_WORKSPACE_MODE
or NONCR_WORKSPACE_MODE
is set to PESSIMISTIC_LOCKING
and the DML operation violates the system setting.LIVE
workspaces, you can change the PESSIMISTIC_LOCKING
setting to OPTIMISTIC_LOCKING.
To see the current Workspace Manager system parameter settings, use the WM_INSTALLATION metadata view.WHERE
clause.WHERE
clause in conjunction with the parameters for the operation.LIVE
workspaces.LIVE
workspaces for the workspace type (continually refreshed or not continually refreshed) for which the parameter is being set.ALLOW_CAPTURE_EVENTS
was set to OFF
.ALLOW_CAPTURE_EVENTS
to ON
, and retry the operation.SetCaptureEvents('ALL_EVENTS','OFF')
, and retry the operation.ON
or OFF
for the capture parameter.ALLOW_MULTI_PARENT_WORKSPACES
to OFF
when one or more multiparent workspaces existed in the system.ALLOW_NESTED_TABLE_COLUMNS
to OFF
when one or more version-enabled tables contained a nested table column.ALLOW_NESTED_TABLE_COLUMNS
was set to OFF
.ALLOW_NESTED_TABLE_COLUMNS
to ON
, and retry the operation.ANALYZE TABLE ... ESTIMATE STATISTICS FOR COLUMNS ...
to collect the histogram statistics; then try the operation again.PRIMARY_KEY_RANGE
.TABLE
.batch_size
parameter value as TABLE
or PRIMARY_KEY_RANGE
.NUMBER_OF_COMPRESS_BATCHES
was invalid.