My Oracle Support Banner

Example of Edition-Based Redefinition using Cross-Edition Triggers (Doc ID 845667.1)

Last updated on FEBRUARY 12, 2018

Applies to:

PL/SQL - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 12th Feb 2018***

Purpose

This document provides a complete reproducible example of Edition-Based Redefinition based on the code samples provided in the Edition-Based Redefinition chapter of the Advanced PLSQL Programmers Guide.

It is split up into 5 logical steps with explanatory notes included in the code.

Note that this example does not execute the final steps to implement the pipe as the default, since this part of the process is irreversible.

Scope

This document is intended for any developer investigating the functionality of Edition-Based redefinition
and wanting something that they can use as a basis for testing the functionality

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1.  Set Up Test Data
 2.  Prepare The Application For Editioning
 3.  Create a New Edition and Modify The Application
 4.  Define Cross-Edition Triggers and Migrate the Data.
 5. Run Some Tests

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.