Oracle Database Workspace Manager Developer's Guide 11g Release 2 (11.2) - 340: 了解Oracle Workspace Manager的使用和参考信息。 E11826-05Sept 2013, Chuck Murray, Bill Beauregard, Ben Speckhard编写。

需积分: 5 135 浏览量更新于2023-11-24 收藏 4.32MB PDF 举报

Oracle Database Workspace Manager Developer's Guide 11g Release 2是一本关于Oracle Workspace Manager的开发指南，它提供了关于如何使用和参考Oracle Workspace Manager的信息。Oracle Workspace Manager是一个使应用程序能够在不同的工作空间中创建工作空间并将表行数据的不同版本进行分组的工具。这本指南的作用是帮助开发人员了解Oracle Workspace Manager的功能和用法。它包含了关于如何创建和管理工作空间、如何在工作空间中组合和切换不同版本的表行数据的详细信息。此外，该指南还提供了对Oracle Workspace Manager的高级功能和高级主题的深入讨论。本指南适用于Oracle Database Workspace Manager Developer's Guide 11g Release 2 (11.2)-340的版本。该版本于2013年9月发布，是Oracle Database Workspace Manager的11.2版本的最新发行版。本指南适用于所有的Oracle用户，无论是从事数据库开发还是数据库管理工作。本指南的主要作者是Chuck Murray，还有其他贡献者包括Bill Beauregard和Ben Speckhard。他们通过为本指南提供关于Oracle Workspace Manager的知识和经验，为用户提供了一个全面的开发指南。此外，本软件和相关文档受版权保护，并受限于使用和披露的许可协议。除非在许可协议中明确允许或法律许可，否则您不得使用、复制或转载该软件和文档。总之，Oracle Database Workspace Manager Developer's Guide 11g Release 2是一本重要的开发指南，它为开发人员们提供了关于Oracle Workspace Manager的详细信息和使用方法。通过这本指南，开发人员可以了解如何利用Oracle Workspace Manager创建和管理工作空间，并在不同的工作空间中组合和切换表行数据的不同版本。

xvi

Convention Meaning

boldface Boldface type indicates graphical user interface elements associated

with an action, or terms defined in text or the glossary.

italic Italic type indicates book titles, emphasis, or placeholder variables for

which you supply particular values.

monospace Monospace type indicates commands within a paragraph, URLs, code

in examples, text that appears on the screen, or text that you enter.

xviii

New Workspace Manager System Parameters

The following are new Workspace Manager system parameters for this release:

■ ADD_UNIQUE_COLUMN_TO_HISTORY_VIEW

■ COMPRESS_PARENT_AFTER_REMOVE

■ KEEP_REMOVED_WORKSPACES_INFO

■ ROW_LEVEL_LOCKING

■ TARGET_PGA_MEMORY

■ USE_SCALAR_TYPES_FOR_VALIDTIME

The Workspace Manager system parameters are documented in Section 1.5.

New Options for the AlterVersionedTable Procedure

The following new options are available for the alter_option parameter of the

AlterVersionedTable procedure:

■ REBUILD_INDEX, which has the following related new parameter_options

parameter keywords: index_owner, index_name, and reverse and

noreverse

■ USE_SCALAR_TYPES_FOR_VALIDTIME and USE_WM_PERIOD_FOR_VALIDTIME

(only one of which can be specified in each call to the procedure)

The AlterVersionedTable procedure is documented in Chapter 4.

New Parameter for the EnableVersioning Procedure

The validTimeRange parameter (WM_PERIOD DEFAULT NULL) has been added for

the EnableVersioning procedure. With this parameter, if you enable valid time support

when you version-enable a table, you can specify an initial valid time range.

The EnableVersioning procedure is documented in Chapter 4.

New Views for Removed Workspaces

The new ALL_REMOVED_WORKSPACES and USER_REMOVED_WORKSPACES

views contain information about workspaces that have been removed during a

RemoveWorkspace operation or a MergeWorkspace operation in which the remove_

workspace parameter value was true, and while the value of the Workspace

Manager system parameter KEEP_REMOVED_WORKSPACES_INFO was ON.

These views are documented in Chapter 5.

Merging Multiple Tables

You can use the MergeTable procedure to apply changes to multiple tables (all rows or

as specified in the WHERE clause) in a workspace to its parent workspace. To specify

multiple tables, specify them in the table_id parameter and separate the names with

commas (for example, 'table1, table2'). In previous releases, you could specify

only a single table name.

The MergeTable procedure is documented in Chapter 4.

Workspace ID Column Added to Static Data Dictionary Views

A numeric WORKSPACE_ID column has been added to the ALL_WORKSPACES and

USER_WORKSPACES views.

These views are documented in Chapter 5.

剩余339页未读，继续阅读

weixin_40191861_zj

粉丝: 84
资源: 1万+

Oracle Database Workspace Manager Developer's Guide 11g Release ...

最新资源

Oracle Database Workspace Manager Developer's Guide 11g Release ...

Oracle Spatial GeoRaster Developer's Guide 11g Release 2 (11.2)

Oracle Database 2 Day Developer's Guide 11g Release 2 (11.2

Oracle 9i SQLJ Developer’s Guide and Reference Release 2 (9.2)

Oracle9i Application Developer’s Guide - Workspace Manager, Release 2 (9.2)

Oracle Internet Directory Application Developer’s Guide Release

Oracle9i Java Stored Procedures Developer’s Guide Release 2 (9.2

Oracle Database Rules Manager and Expression Developer's Guide

Workspace Manager Developer's Guide.pdf

Oracle Database QOS Management User's Guide 11g -112.pdf

Oracle8i Application Developer’s Guide - Advanced Queuing Releas

最新资源