62 DBMS_EDITIONS_UTILITIES

The DBMS_EDITIONS_UTILITIES package provides helper functions for edition-related operations.

The chapter contains the following topics:

DBMS_EDITIONS_UTILITIES Overview

The DBMS_EDITIONS_UTILITIES package implements an interface which provides helper functions for edition-related operations.

DBMS_EDITIONS_UTILITIES Security Model

This package is owned by SYS with execute access granted to PUBLIC. It runs with invoker's rights, that is, with the security profile of the caller.

DBMS_EDITIONS_UTILITIES Exceptions

The table in this topic lists exception messages created by DBMS_EDITIONS_UTILITIES.

Table 62-1 DBMS_EDITIONS_UTILITIES Error Messages

Error Description

ORA-38817

Insufficient privileges

ORA-942

Missing table

Summary of DBMS_EDITIONS_UTILITIES Subprograms

This table lists and describes the DBMS_EDITIONS_UTILITIES package subprograms.

Table 62-2 DBMS_EDITIONS_UTILITIES Package Subprograms

Subprogram Description

SET_EDITIONING_VIEWS_READ_ONLY Procedure

Given the schema name and table name, this procedure sets the corresponding editioning views in all editions to READ ONLY or READ/WRITE

SET_NULL_COLUMN_VALUES_TO_EXPR Procedure

For use only during an edition-based redefinition (EBR) exercise

SET_EDITIONING_VIEWS_READ_ONLY Procedure

Given the schema name and table name, this procedure sets the corresponding editioning views in all editions to READ ONLY or READ/WRITE.

Syntax

DBMS_EDITIONS_UTILITIES.SET_EDITIONING_VIEWS_READ_ONLY (
   table_name IN VARCHAR2,
   owner      IN VARCHAR2 DEFAULT NULL,
   read_only  IN BOOLEAN  DEFAULT TRUE);

Parameters

Table 62-3 SET_EDITIONING_VIEWS_READ_ONLY Procedure Parameters

Parameter Description

table_name

Base table of the editioning views

owner

Base table schema. The default (or NULL) is the current schema.

read_only

TRUE to set the views to read-only; FALSE (or NULL) sets the views to READ/WRITE. Default is TRUE.

Usage Notes

The user must have the following privileges:

  • Owner of the table, or have the ALTER ANY TABLE system privileges

  • USE object privilege on all the editions for which the views are defined

SET_NULL_COLUMN_VALUES_TO_EXPR Procedure

This procedure replaces NULL values in a replacement column with the value of an expression.

The expression evaluation cost is deferred to future updates and queries. The procedure is intended for use only during an edition-based redefinition (EBR) exercise.

See Also:

Syntax

DBMS_EDITIONS_UTILITIES.SET_NULL_COLUMN_VALUES_TO_EXPR;
   table_name    IN  VARCHAR2,
   column_name   IN  VARCHAR2,
   expression    IN  VARCHAR2);

Parameters

Table 62-4 SET_NULL_COLUMN_VALUES_TO_EXPR Procedure Parameters

Parameter Description

table_name

A potentially schema-qualified table name

column_name

Name of the column to be updated

expression

An expression composed of columns in the same table, constants, and SQL functions